X-Original-To: pgsql-admin@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 83764924C1B for ; Fri, 23 May 2003 11:47:16 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 69306-07 for ; Fri, 23 May 2003 11:46:59 -0400 (EDT) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by developer.postgresql.org (Postfix) with ESMTP id D3AAC924FC1 for ; Fri, 23 May 2003 11:12:25 -0400 (EDT) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.9.3/8.9.3) with ESMTP id TAA07078; Fri, 23 May 2003 19:12:14 +0400 (MSD) Date: Fri, 23 May 2003 19:12:14 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Jodi Kanter Cc: Postgres Admin List Subject: Re: upgrade issue In-Reply-To: <3ECE29A4.2010107@virginia.edu> Message-ID: References: <3ECE29A4.2010107@virginia.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/330 X-Sequence-Number: 8892 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, > line 57. > at (eval 4) line 3 > Compilation failed in require at (eval 4) line 3, 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 solved 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