Trying to upgrade to PostgreSQL 8.2.4

General support questions including new installations
Post Reply
dbird
Posts: 1
Joined: 2007/04/24 05:44:38

Trying to upgrade to PostgreSQL 8.2.4

Post by dbird » 2007/04/24 05:56:09

I'm trying to install postgreSQL 8.2.4 on CentOS 5

I downloaded the RHEL 4 rpm files for postgreSQL

I tried to install the first RPM

rpm -ivh postgresql-libs-8.2.4-1PGDG.i686.rpm

and I got the following error

Failed dependencies:
libcrypto.so.4
libssl.so.4

from some research they are in the following package

libcrypto.so.4 --> openssl-devel-0.9.7a-43.14
libssl.so.4 --> openssl-devel-0.9.7a-43.14

I did a

yum search openssl-devel

open ssl-devel.i383 0.9.8b.3.el5 installed

any Ideas?

Lenard
Posts: 2283
Joined: 2005/11/29 02:35:25
Location: Indiana

Re: Trying to upgrade to PostgreSQL 8.2.4

Post by Lenard » 2007/04/24 11:19:22

Hmmmm............The output from the typed commands;

yum whatprovides libcrypto.so.4
yum whatprovides libssl.so.4

Shows that you need openssl097a installed: yum install openssl097a

FYI: it is a good idea to install multiple related packages at the same time, plae them all in the same location where they are the only rpm packages and type something like; rpm -Uvh *.rpm

whampton
Posts: 8
Joined: 2007/05/08 21:02:12

Re: Trying to upgrade to PostgreSQL 8.2.4

Post by whampton » 2007/05/09 15:05:43

I am trying the RHEL 5 versions, but when I try to /sbin/service postgresql initdb it fails with an error "WARNING: could not read time zone file "Default": permission denied", FATAL: invalid value for parameter "timezone_abbreviations": "Default".

Should one use the RHEL4 or RHEL4 versions with CentOS 5? Any idea about the above issue?

Lenard
Posts: 2283
Joined: 2005/11/29 02:35:25
Location: Indiana

Re: Trying to upgrade to PostgreSQL 8.2.4

Post by Lenard » 2007/05/09 15:48:37

Errr, this is not hard to figure out;

CentOS(version) == RHEL(version.update)

Examples:

CentOS4.4 == RHEL4update4
CentOS5 ==RHEL5

As far as the issue, sorry I do not use PostgreSQL.

whampton
Posts: 8
Joined: 2007/05/08 21:02:12

Re: Trying to upgrade to PostgreSQL 8.2.4

Post by whampton » 2007/05/09 16:54:33

Per Tom Lane (postgresql developer), I tried using strace but it dies at the same place each time:

su postgres -c "strace initdb -D /var/lib/pgsql/data"

..
write(4, "insert OID = 1153 (timestampz_"...., 116WARNING: could
not read.....
... = -1 EPIPE (Broken pipe)

/etc/localtime is:
TZif2\0... UTC... UTC0

locale is en_US.UTF-8

I downloaded the source RPM postgresql-8.2.4-1PGDG.src.rpm and when I tried to rpmbuild --rebuild *src.rpm", I got an error about "this platform is not thread-safe".

For now, I'm reverting to the 8.1 version that came with CentOS5.

indyjish
Posts: 20
Joined: 2006/10/13 15:29:08
Contact:

Re: Trying to upgrade to PostgreSQL 8.2.4

Post by indyjish » 2007/05/09 17:07:11

[quote]
dbird wrote:

yum search openssl-devel

open ssl-devel.i383 0.9.8b.3.el5 installed

any Ideas?[/quote]

Hmm. I'm running PG 8.2.4 on CentOS 5. Here are the packages I have installed:

[root@dhcppc0 josh]# rpm -qa | grep postg
postgresql-devel-8.2.4-1PGDG
postgresql-plperl-8.2.4-1PGDG
postgresql-libs-8.2.4-1PGDG
postgresql-contrib-8.2.4-1PGDG
postgresql-server-8.2.4-1PGDG
postgresql-pltcl-8.2.4-1PGDG
postgresql-plpython-8.2.4-1PGDG
postgresql-8.2.4-1PGDG

[root@dhcppc0 josh]# rpm -qa | grep ssl
openssl-0.9.8b-8.3.el5
openssl-devel-0.9.8b-8.3.el5
mod_ssl-2.2.3-6.el5.centos.1
openssl097a-0.9.7a-9

I downloaded and installed the RHEL5 packages without a problem; doing /sbin/service postgresql initdb and /sbin/service postgresql start both ran successfully. Perhaps a yum update would do the trick?

Cheers,
-J

whampton
Posts: 8
Joined: 2007/05/08 21:02:12

Re: Trying to upgrade to PostgreSQL 8.2.4

Post by whampton » 2007/05/09 19:57:32

The problem is permissions on /usr/share/pgsql/timezonesets (owned root:root 700). To fix:
chmod 755 /usr/share/pgsql/timezonesets
service postgresql initdb
-- customize your /var/lib/pgsql/data/postgresql.conf and pg_hba.conf files
service postgresql start
[Thanks Tom Lane, postgresql mailing list]

Post Reply