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