Re: well, shoot. Error loading Pg.so

Well, a couple of suggestions:

Restore the /usr/lib/perl5/site_perl directory from a working backup.

Try doing a ./configure --with-perl in the src directory, then go into
interfaces/Perl5 and type make;make install.  Maybe the currently installed
src dir wasn't correct.

Might also want to check that /usr/local/pgsql/lib is in your
/etc/ld.so.conf file and re-run ldconfig.  (Probably should do this before
trying the rebuild of the perl interface)


At 03:04 PM 4/19/00, Steve Wolfe wrote:

>    Today, our newest employee thought he'd upgrade the Perl interface to
>Postgres.  So, he went into the source directory, and did "gmake install"
>in the /src/interfaces/Perl5 directory.  Now, everything's broken.  Trying
>to use it, we get:
>
>perl: error in loading shared libraries:
>/usr/lib/perl5/site_perl/i386-linux/auto/Pg/Pg.so: undefined symbol:
>PQconnectdb
>
>   Now, here's where it gets reeeeely nice.  The last system admin, who is
>now gone, has about 50 copies of the postgress source lying around on the
>disk (really bright guy).  They're all 6.5.3, except for the rpm's for
>6.5.3-2 and 6.5.3-2nl.
>
>   So, at this point, I have two choices:  Dump all data, reinstall, and
>restore (a few days of dumping/restoring), or some nice soul can suggest
>how I can fix this....
>
>   Any suggestions?
>
>steve