Yum Repository for Postgres 8.2.5

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(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.

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(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.

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/

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?

-----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-----

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/