Обсуждение: Postgresql won't run after upgrade to fc5
Hi,
I accidently upgraded my linux/intel to fc5 from fc4 and
something happened...
Postgres cannot find some needed shared libraries any
more.
Can anyone offer any clues?
Jerry
/usr/bin/postmaster: error while loading shared
libraries: libssl.so.5: cannot open shared object file: No such file
or directory
[root@localhost lib]# rpm -qa | grep postgres
postgresql-tcl-8.1.3-1PGDG
postgresql-server-8.1.3-1PGDG
postgresql-python-8.1.3-1PGDG
postgresql-docs-8.1.3-1PGDG
postgresql-libs-8.1.3-1
postgresql-jdbc-8.1.3-1PGDG
postgresql-contrib-8.1.3-1PGDG
postgresql-devel-8.1.3-1PGDG
postgresql-8.1.3-1PGDG
postgresql-pl-8.1.3-1PGDG
[jerry@localhost bin]$ ldd postgres
linux-gate.so.1 => (0x00d07000)
libpam.so.0 => /lib/libpam.so.0 (0x004d9000)
libssl.so.5 => not found
libcrypto.so.5 => not found
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00571000)
libz.so.1 => /usr/lib/libz.so.1 (0x00839000)
libreadline.so.5 => /usr/lib/libreadline.so.5 (0x00a5b000)
libtermcap.so.2 => /lib/libtermcap.so.2 (0x00eb4000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x008a8000)
libresolv.so.2 => /lib/libresolv.so.2 (0x00111000)
libnsl.so.1 => /lib/libnsl.so.1 (0x00959000)
libdl.so.2 => /lib/libdl.so.2 (0x00124000)
libm.so.6 => /lib/libm.so.6 (0x0038f000)
libc.so.6 => /lib/libc.so.6 (0x00128000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x00c8c000)
libaudit.so.0 => /lib/libaudit.so.0 (0x0025b000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00988000)
/lib/ld-linux.so.2 (0x00cb9000)
libkrb5support.so.0 => /usr/lib/libkrb5support.so.0
(0x00d54000)
[root@localhost lib]# ls -al libcrypto*
-rw-r--r-- 1 root root 2320564 Feb 12 03:33 libcrypto.a
lrwxrwxrwx 1 root root 29 Mar 21 09:00 libcrypto.so -> ../../lib/
libcrypto.so.0.9.8a
[root@localhost lib]# ls -al libssl*
-rw-r--r-- 1 root root 706805 Feb 15 02:41 libssl3.so
-rw-r--r-- 1 root root 439208 Feb 12 03:33 libssl.a
lrwxrwxrwx 1 root root 26 Mar 21 09:00 libssl.so -> ../../lib/
libssl.so.0.9.8a
Hi, On Tue, 2006-03-21 at 17:02 -0500, Jerry LeVan wrote: > I accidently upgraded my linux/intel to fc5 from fc4 and > something happened... > > Postgres cannot find some needed shared libraries any > more. We (PGDG) don't have RPMs for FC5 yet. However Fedora Core ships with 8.1.3 RPMs already. So I'd install their RPMs. This should not cause a problem since the database versions are the same. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
Hmmm, It appears that they bumped libcryto and libssl (living in /lib ) by a smidgen. I might try moving the old versions from an existing fc4 over to fc5. If that does not work then I guess I will need to uninstall the PGDG rpms and install the FC5 rpms. Thanks Jerry On Mar 21, 2006, at 5:10 PM, Devrim GUNDUZ wrote: > Hi, > > On Tue, 2006-03-21 at 17:02 -0500, Jerry LeVan wrote: >> I accidently upgraded my linux/intel to fc5 from fc4 and >> something happened... >> >> Postgres cannot find some needed shared libraries any >> more. > > We (PGDG) don't have RPMs for FC5 yet. However Fedora Core ships with > 8.1.3 RPMs already. So I'd install their RPMs. This should not cause a > problem since the database versions are the same. > > Regards, > > -- > The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > Managed Services, Shared and Dedicated Hosting > Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/ >
Hi, On Tue, 2006-03-21 at 17:38 -0500, Jerry LeVan wrote: > I might try moving the old versions from an existing > fc4 over to fc5. Don't do that. You may break he consistency of your new box. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
On Wed, Mar 22, 2006 at 00:10:53 +0200, Devrim GUNDUZ <devrim@commandprompt.com> wrote: > Hi, > > On Tue, 2006-03-21 at 17:02 -0500, Jerry LeVan wrote: > > I accidently upgraded my linux/intel to fc5 from fc4 and > > something happened... > > > > Postgres cannot find some needed shared libraries any > > more. > > We (PGDG) don't have RPMs for FC5 yet. However Fedora Core ships with > 8.1.3 RPMs already. So I'd install their RPMs. This should not cause a > problem since the database versions are the same. I wouldn't trust that if I didn't have to. FC5 is using a different version of gcc than FC4. In addition they might have used different build options than the PGDG did.
I copied over the missing libs from one of my other fc4 systems and postgresql seems happy and I have not experienced any other problems so far... Jerry On Mar 21, 2006, at 11:46 PM, Bruno Wolff III wrote: > On Wed, Mar 22, 2006 at 00:10:53 +0200, > Devrim GUNDUZ <devrim@commandprompt.com> wrote: >> Hi, >> >> On Tue, 2006-03-21 at 17:02 -0500, Jerry LeVan wrote: >>> I accidently upgraded my linux/intel to fc5 from fc4 and >>> something happened... >>> >>> Postgres cannot find some needed shared libraries any >>> more. >> >> We (PGDG) don't have RPMs for FC5 yet. However Fedora Core ships with >> 8.1.3 RPMs already. So I'd install their RPMs. This should not >> cause a >> problem since the database versions are the same. > > I wouldn't trust that if I didn't have to. FC5 is using a different > version > of gcc than FC4. In addition they might have used different build > options > than the PGDG did.
Bruno Wolff III <bruno@wolff.to> writes:
> Devrim GUNDUZ <devrim@commandprompt.com> wrote:
>> We (PGDG) don't have RPMs for FC5 yet. However Fedora Core ships with
>> 8.1.3 RPMs already. So I'd install their RPMs. This should not cause a
>> problem since the database versions are the same.
> I wouldn't trust that if I didn't have to. FC5 is using a different version
> of gcc than FC4. In addition they might have used different build options
> than the PGDG did.
The gcc point is valid, but AFAIK the PGDG RPMs are using the same build
options as the Red Hat RPMs. There are various small differences in the
specfiles and auxiliary files that we should try to converge on, but I
don't see any fundamental incompatibilities.
(In case you're not totally clear on the situation: the Red Hat/Fedora
RPMs are my fault, the PGDG ones are Devrim's ;-) We are not talking
about some remote unaccountable sources here.)
regards, tom lane
Bruno Wolff III wrote: > I wouldn't trust that if I didn't have to. FC5 is using a different > version of gcc than FC4. That is only a problem if you are using C++. -- Peter Eisentraut http://developer.postgresql.org/~petere/