CentOS 4 RPMs for 8.2.4?

Started by Steve Wamplerover 18 years ago6 messagesgeneral
Jump to latest
#1Steve Wampler
swampler@noao.edu

I'd like to update from 8.1.9 to 8.2.4 to take advantage of
the multiple value INSERT but don't see at least two of the
RPMs for 8.2.4 that I need.

The installed 8.1.9 RPMs (from the centosplus repository) are:

postgresql-8.1.9-1.el4s1.1
postgresql-contrib-8.1.9-1.el4s1.1
postgresql-devel-8.1.9-1.el4s1.1
postgresql-docs-8.1.9-1.el4s1.1
postgresql-jdbc-8.1.4-1.centos.1
postgresql-libs-8.1.9-1.el4s1.1
postgresql-odbc-08.01.0200-2.el4s1.3
postgresql-pl-8.1.9-1.el4s1.1
postgresql-python-8.1.9-1.el4s1.1
postgresql-server-8.1.9-1.el4s1.1
postgresql-tcl-8.1.9-1.el4s1.1
postgresql-test-8.1.9-1.el4s1.1

while the RH4 RPMs at postgresql.org are:

compat-postgresql-libs-4-2PGDG.rhel4.i686.rpm
postgresql-8.2.4-1PGDG.i686.rpm
postgresql-contrib-8.2.4-1PGDG.i686.rpm
postgresql-devel-8.2.4-1PGDG.i686.rpm
postgresql-docs-8.2.4-1PGDG.i686.rpm
postgresql-libs-8.2.4-1PGDG.i686.rpm
postgresql-plperl-8.2.4-1PGDG.i686.rpm
postgresql-plpython-8.2.4-1PGDG.i686.rpm
postgresql-pltcl-8.2.4-1PGDG.i686.rpm
postgresql-server-8.2.4-1PGDG.i686.rpm
postgresql-test-8.2.4-1PGDG.i686.rpm

I need the Java and Python interfaces supplied with
(from 8.1.9):

postgresql-jdbc-8.1.4-1.centos.1
postgresql-python-8.1.9-1.el4s1.1

Can I just continue to use those with the above 8.2.4
RPMs? What about the odbc support, which would be useful,
but not as critical?

While I'm at it, I also need libpqxx working for C++. The last
set of RPMs I've found are really for PG7, but they seem
to work alright with PG 8.1.x (after some trickery to get them
to install with and use libpq.so.4 instead of libpq.so.3).

Does anyone know if this version:

libpqxx-devel-2.6.9-1.el4.rf
libpqxx-2.6.9-1.el4.rf

will work with 8.2.4?

Thanks!
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.

#2Steve Wampler
swampler@noao.edu
In reply to: Steve Wampler (#1)
Re: CentOS 4 RPMs for 8.2.4?

Steve Wampler wrote:

I'd like to update from 8.1.9 to 8.2.4 to take advantage of
the multiple value INSERT but don't see at least two of the
RPMs for 8.2.4 that I need.
...
I need the Java and Python interfaces supplied with
(from 8.1.9):

postgresql-jdbc-8.1.4-1.centos.1
postgresql-python-8.1.9-1.el4s1.1

Can I just continue to use those with the above 8.2.4
RPMs? What about the odbc support, which would be useful,
but not as critical?

To answer my own question: both of the above two RPMs work fine
with 8.2.4. Dunno about obdc, but imagine it would also work.

While I'm at it, I also need libpqxx working for C++. The last
set of RPMs I've found are really for PG7, but they seem
to work alright with PG 8.1.x (after some trickery to get them
to install with and use libpq.so.4 instead of libpq.so.3).

Does anyone know if this version:

libpqxx-devel-2.6.9-1.el4.rf
libpqxx-2.6.9-1.el4.rf

will work with 8.2.4?

Yes, provided you symlink /usr/lib/libpq.so.4 as /usr/lib/libpq.so.3.
(Might work by symlinking /usr/lib/libpq.so.5 as /usr/lib/libpq.so.3, but
I haven't tried that.)
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.

#3Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: Steve Wampler (#1)
Re: CentOS 4 RPMs for 8.2.4?

Hi,

On Sat, 2007-07-21 at 15:57 -0700, Steve Wampler wrote:

I need the Java and Python interfaces supplied with
(from 8.1.9):

postgresql-jdbc-8.1.4-1.centos.1
postgresql-python-8.1.9-1.el4s1.1

The actual problem is I did not build jdbc packages for latest
releases.

I just build 8.2 srpm, will test and publish it until weekend. Keep eye
on Planet PostgreSQL -- I will blog after I push the packages to FTP
repos.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

#4Ow Mun Heng
Ow.Mun.Heng@wdc.com
In reply to: Devrim GÜNDÜZ (#3)
Re: CentOS 4 RPMs for 8.2.4?

On Wed, 2007-07-25 at 19:32 +0300, Devrim GÜNDÜZ wrote:

Hi,

On Sat, 2007-07-21 at 15:57 -0700, Steve Wampler wrote:

I need the Java and Python interfaces supplied with
(from 8.1.9):

postgresql-jdbc-8.1.4-1.centos.1
postgresql-python-8.1.9-1.el4s1.1

The actual problem is I did not build jdbc packages for latest
releases.

I just build 8.2 srpm, will test and publish it until weekend. Keep eye
on Planet PostgreSQL -- I will blog after I push the packages to FTP
repos.

Er.. can I ask where I can find the actual difference between 8.1 and
the 8.2 branch? Like the OP, I too would like to get 8.2.4 since it's
the latest stable version and since I'm installing it for use for the
1st time, I _should_ choose the latest stable branch.

I've just downloaded 8.2.4 rpms for rhel4 per the OP. Do I have to
install everything or.. will some parts do?

#5David Siebert
david@eclipsecat.com
In reply to: Steve Wampler (#1)
Yum Repository for Postgres 8.2.5

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I am using CentOS 5 and would like to update to 8.2.5. Does anyone know
of a repository that carries it? RedHat 5 should work as well.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3-nr1 (Windows XP)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQEVAwUBRvk5peLnn4qAcbUGAQKM0gf8CmRQF0YllkW7y7bjA0ybbki29rRdGhaD
/drowClY5EHtrU7ClF6aQ+gLk7LR4cXAs4AFGLtTGJSIncL9W9OiivzgryWzfYCQ
H6K21TQj+IFC5pdhUZgBLQMTLU7LFSpT4IQztR59o+izYdRZJWh7OH2s8JdLMHdE
StEc/H3igvDmpE3l1NlS6BBAHRYH/tCR9FCb+IODpZBSO5Xppgv+6Hk+pEZ3ncfJ
ONaIkNfCsxhhDtE02ih3fmp7Qusd2IysL+EWEl6QqLqwGuHEY9fseMn1636SK4YF
qsSX1K+6Bhtm5D5CmjtxMw1nw3s2DoU1gjpdAw8PH6chAw9T0pwR5Q==
=LPq9
-----END PGP SIGNATURE-----

#6Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: David Siebert (#5)
Re: Yum Repository for Postgres 8.2.5

Hi,

On Tue, 2007-09-25 at 12:39 -0400, David Siebert wrote:

I am using CentOS 5 and would like to update to 8.2.5. Does anyone
know of a repository that carries it? RedHat 5 should work as well.

I am about to create a yum repository for PGDG RPMs. The infrastructure
is ready, but I have some other priorities nowadays. I think it will be
available next weekend or so.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/