Re: [GENERAL] Restore from a dead machine.

2001-05-17 Thread User JOHN



On Wed, 16 May 2001, Tom Lane wrote:

 User JOHN [EMAIL PROTECTED] 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



Re: [GENERAL] Restore from a dead machine.

2001-05-17 Thread John Burski

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 [EMAIL PROTECTED] 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




---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [GENERAL] Restore from a dead machine.

2001-05-17 Thread jtp



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


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



[GENERAL] Restore from a dead machine.

2001-05-16 Thread User JOHN


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.


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [GENERAL] Restore from a dead machine.

2001-05-16 Thread Tom Lane

User JOHN [EMAIL PROTECTED] 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

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])