In case anyone besides me is interested, installing these packages on CentOS4.2 seems to work. You can determine the correct mirror to use from:
http://www.postgresql.org/ftp/binary/v8.0.4/linux/rpms/redhat/rhel- es-4/
The rpm command that I used was:
rpm --upgrade --nodeps --hash -v <package url>
Packages in order of installation:
ftp://ftp3.ca.postgresql.org/pub/binary/v8.0.4/linux/rpms/redhat/rhe l-es-4/postgresql-libs-8.0.4-2PGDG.i686.rpm
ftp://ftp3.ca.postgresql.org/pub/binary/v8.0.4/linux/rpms/redhat/rhe l-es-4/postgresql-contrib-8.0.4-2PGDG.i686.rpm
ftp://ftp3.ca.postgresql.org/pub/binary/v8.0.4/linux/rpms/redhat/rhe l-es-4/postgresql-docs-8.0.4-2PGDG.i686.rpm
ftp://ftp3.ca.postgresql.org/pub/binary/v8.0.4/linux/rpms/redhat/rhe l-es-4/postgresql-pl-8.0.4-2PGDG.i686.rpm
ftp://ftp3.ca.postgresql.org/pub/binary/v8.0.4/linux/rpms/redhat/rhe l-es-4/postgresql-8.0.4-2PGDG.i686.rpm
ftp://ftp3.ca.postgresql.org/pub/binary/v8.0.4/linux/rpms/redhat/rhe l-es-4/postgresql-server-8.0.4-2PGDG.i686.rpm
ftp://ftp3.ca.postgresql.org/pub/binary/v8.0.4/linux/rpms/redhat/rhe l-es-4/postgresql-test-8.0.4-2PGDG.i686.rpm
We are using 8.0.4 for development of a new application on a dedicated development server so stability and data conversion issues do not concern us for the moment. You are nonetheless advised not to install 8.0.4 over a 7.4.8 installation without first unloading all of the postgreSQL databases that you wish to preserve under 8.0.4.
Regards, Jim
-- *** e-mail is not a secure channel *** mailto:byrnejb.<token>@harte-lyne.ca James B. Byrne Harte & Lyne Limited vox: +1 905 561 1241 9 Brockley Drive fax: +1 905 561 0757 Hamilton, Ontario <token> = hal Canada L8E 3C3
On 10/26/05, James B. Byrne ByrneJB@harte-lyne.ca wrote:
In case anyone besides me is interested, installing these packages on CentOS4.2 seems to work. You can determine the correct mirror to use from:
http://www.postgresql.org/ftp/binary/v8.0.4/linux/rpms/redhat/rhel- es-4/
The rpm command that I used was:
rpm --upgrade --nodeps --hash -v <package url>
<snipped>
Thanks Jim. Very useful guide - used it to upgrade our server to 8.0.4 (7.x.x would've been fine generally but I wanted the new ALTER COLUMN ... ALTER TABLE ... TYPE command). Seems --nodeps was the missing flag needed to install the packages without complaining about dependencies.
-- Stand before it and there is no beginning. Follow it and there is no end. Stay with the ancient Tao, Move with the present.
James B. Byrne wrote:
In case anyone besides me is interested, installing these packages on CentOS4.2 seems to work. You can determine the correct mirror to use from:
http://www.postgresql.org/ftp/binary/v8.0.4/linux/rpms/redhat/rhel- es-4/
The rpm command that I used was:
rpm --upgrade --nodeps --hash -v <package url>
errr... --nodeps ? what for ?
- K
Karanbir Singh wrote:
James B. Byrne wrote:
In case anyone besides me is interested, installing these packages on CentOS4.2 seems to work. You can determine the correct mirror to use from:
http://www.postgresql.org/ftp/binary/v8.0.4/linux/rpms/redhat/rhel- es-4/ The rpm command that I used was:
rpm --upgrade --nodeps --hash -v <package url>
errr... --nodeps ? what for ?
- K
1. DON'T USE nodeps
It's because the binaries don't have libpq.so.3 (if I remember correctly). Installing it this way will just break those things that need that library.
Instead.... install the compat-postgresql-libs
http://developer.postgresql.org/~devrim/rpms/compat/compat-postgresql-libs-3...
-Mike
On 25 Oct 2005 at 15:11, Michael Best wrote:
<snip>
- DON'T USE nodeps
It's because the binaries don't have libpq.so.3 (if I remember correctly). Installing it this way will just break those things that need that library.
Instead.... install the compat-postgresql-libs
http://developer.postgresql.org/~devrim/rpms/compat/compat-postgresql-libs-3...
Another option might be to simply leave the original postgresql-libs- 7.x package installed. On CentOS-3, at least, there's no conflict between rh-postgresql-libs-7.3.10-1 (which also provides libpq.so.3) and postgresql-libs-8.0.3-1PDG (built from PostgreSQL supplied SRPM).
---- Nels Lindquist <*> Information Systems Manager Morningstar Air Express Inc.
-
James B. Byrne -
Karanbir Singh -
Matt Arnilo S. Baluyos (Mailing Lists) -
Michael Best -
Nels Lindquist