Обсуждение: Restore from a dead machine.

Hello there,
  I have a FreeBSD machine that died earlier this week and i have been
attempting to restore it (or rather it's contents).  Postgres has caused
somewhat of a problem in this area.

I was running 7.0.1 and decided to upgrade to 7.0.3 since i have to
reinstall it anyways.  The install has gone fine and i can restore the old
database back into the new postgres install without any problems.

But when i try to run any of the perl scripts designed for the database
I'm getting the following error:

Can't locate Pg.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
/usr/libdata/perl/5.00503
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005 .) at ./top25.pl line 2.

Line 2 of the specific program reads:    Use Pg;

Nothing seemed out of the ordinary during the config/make/install process,
and the only thing i did non standard was to run the config as:
./configure --with-perl --with-odbc.


So can anyone tell me why my perl modules don't like me?  Or more
importantly how to get them to play friendly.

If it makes a difference i have a backup of the old (7.0.1) install and a
bunch of other directories under usr.  I can locate the Pg.pm and DBI.pm
in what would have been /usr/local/lib/perl5/site_perl/5.005/i386-freebsd.

Thanks in advance.
And apologies for typos / sticky keys.

.jtp
John T Porvaznik
Person type person
Akadine Press Inc.

> Can't locate Pg.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
> /usr/libdata/perl/5.00503
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> /usr/local/lib/perl5/site_perl/5.005 .) at ./top25.pl line 2.
>
> Line 2 of the specific program reads:    Use Pg;

Make sure that the user running the script has read perms on the Pg.pm file.

--
Alex Howansky
Wankwood Associates
http://www.wankwood.com/

User JOHN <john@akadine.com> writes:
> But when i try to run any of the perl scripts designed for the database
> I'm getting the following error:

> Can't locate Pg.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
> /usr/libdata/perl/5.00503
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> /usr/local/lib/perl5/site_perl/5.005 .) at ./top25.pl line 2.

Perhaps what it's really failing to find is libpq.so.  Are you sure your
dynamic loader's search path will find libpq?

            regards, tom lane

On Wed, 16 May 2001, Tom Lane wrote:

> User JOHN <john@akadine.com> writes:
> > But when i try to run any of the perl scripts designed for the database
> > I'm getting the following error:
>
> > Can't locate Pg.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
> > /usr/libdata/perl/5.00503
> > /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> > /usr/local/lib/perl5/site_perl/5.005 .) at ./top25.pl line 2.
>
> Perhaps what it's really failing to find is libpq.so.  Are you sure your
> dynamic loader's search path will find libpq?
>
>             regards, tom lane

I was having trouble with libraries prior to this perl issue.  I've since
fixed this issue (the libpq.so) but the Perl issue remains.
I've looked in all the directories implicated and none of them hold Pg.pm.

I've seen this message before - it appears when, like you indicated, the
specified module can't be found in any of the directories specified in the Perl
@INC array.

If you can locate the Pg.pm module on your system, copy it to one of the
directories specified (a symbolic link might work, too, but I've not tried
that).

Another option might be to download and install the latest Pg module from CPAN.

Best Regards,

User JOHN wrote:

> On Wed, 16 May 2001, Tom Lane wrote:
>
> > User JOHN <john@akadine.com> writes:
> > > But when i try to run any of the perl scripts designed for the database
> > > I'm getting the following error:
> >
> > > Can't locate Pg.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
> > > /usr/libdata/perl/5.00503
> > > /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> > > /usr/local/lib/perl5/site_perl/5.005 .) at ./top25.pl line 2.
> >
> > Perhaps what it's really failing to find is libpq.so.  Are you sure your
> > dynamic loader's search path will find libpq?
> >
> >                       regards, tom lane
>
> I was having trouble with libraries prior to this perl issue.  I've since
> fixed this issue (the libpq.so) but the Perl issue remains.
> I've looked in all the directories implicated and none of them hold Pg.pm.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
John Burski
Data Processing Manager
911EP
First in LEDs... The solid state warning light leader.
1-800-863-6911

Thanks all for the help.  I've got it working.  I remade the perl module
and found that there were some directories/files it wanted to write to
that it couldn't.  So i allowed those permissions and remade install and
everything worked swell.

thanks for the help.
.jtp