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?
Trying to upgrade to PostgreSQL 8.2.4
Re: Trying to upgrade to PostgreSQL 8.2.4
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
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
Re: Trying to upgrade to PostgreSQL 8.2.4
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?
Should one use the RHEL4 or RHEL4 versions with CentOS 5? Any idea about the above issue?
Re: Trying to upgrade to PostgreSQL 8.2.4
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.
CentOS(version) == RHEL(version.update)
Examples:
CentOS4.4 == RHEL4update4
CentOS5 ==RHEL5
As far as the issue, sorry I do not use PostgreSQL.
Re: Trying to upgrade to PostgreSQL 8.2.4
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.
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.
Re: Trying to upgrade to PostgreSQL 8.2.4
[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
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
Re: Trying to upgrade to PostgreSQL 8.2.4
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]
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]