Re: upgrade issue - Mailing list pgsql-admin

Recompiling Perl DBI is not a practical option. Did the developers realize that a major version upgrade to libpq was going to break Perl DBI/DBD-Pg?
Current versions of DBD-Pg use that libpg.so.2.


Oleg Bartunov wrote:

Read this:

http://fts.postgresql.org/db/msg.html?mid=1361754

Oleg
On Fri, 23 May 2003, Jodi Kanter wrote:

We just upgraded one of our Red Hat 7.3 machines from postgresql version
7.2.3 to version 7.3.2. All seemed to go smoothly until we received an
error via our web interface. The following error occurred:

install_driver(Pg) failed: Can't load
'/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/Pg/Pg.so' for module
DBD::Pg: libpq.so.2: cannot open shared object file: No such file or
directory at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206,
<OR> line 57.
 at (eval 4) line 3
Compilation failed in require at (eval 4) line 3, <OR> line 57.
Perhaps a required shared library or dll isn't installed where expected
 at sessionlib.pl line 1507

The Pg driver is present, and was working before the upgrade. From this
error I understand that Pg.so can't load libpq.so.2. No surprise since
there is no /usr/lib/libpq.so.2   It appears that a symlink was created
to file that does not exist.

We sol
ved the problem by moving libpq.so.2 from another machine. That
machine has not been upgraded yet and is still running postgresql
version 7.2.3.

I was hoping someone could give me some insight to why this occured. Did
we miss some part of the installation?  I still have two machines to
upgrade and would like to avoid this on the others. The rpms all
appeared to have run without trouble. So, why didn't it install?

Thanks
Jodi

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83