Thread: 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