Thread: Do I need to rebuild php-pgsql for 8.2.3

Do I need to rebuild php-pgsql for 8.2.3

From

"Michael Dengler"

Date:

10 April 2007, 19:45:18

Hi,

I'm using RHEL4 and wondering if I need to upgrade the php and php-pgsql packages when upgrading from Postgres 7.4.1 to 8.2.3.

Any Help?

Thanks

Mike

Re: Do I need to rebuild php-pgsql for 8.2.3

From

"Guillaume Smet"

Date:

10 April 2007, 20:55:14

On 4/10/07, Michael Dengler <michael.dengler@gmail.com> wrote:
> I'm using RHEL4 and wondering if I need to upgrade the php and php-pgsql
> packages when upgrading from Postgres 7.4.1 to 8.2.3.

No you don't. Devrim Gunduz provides compat RPM for a long time now.

See http://developer.postgresql.org/~devrim/rpms/compat/ and choose
the correct package for your architecture.

--
Guillaume

Re: Do I need to rebuild php-pgsql for 8.2.3

From

Devrim GÜNDÜZ

Date:

10 April 2007, 21:01:22

Hi,

On Tue, 2007-04-10 at 22:55 +0200, Guillaume Smet wrote:
> See http://developer.postgresql.org/~devrim/rpms/compat/ and choose
> the correct package for your architecture.

... or better, each RHEL4 directory in our FTP site has compat package
(that directory is not up2date now).

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/

Attachment

signature.asc

Re: Do I need to rebuild php-pgsql for 8.2.3

From

"Michael Dengler"

Date:

11 April 2007, 17:25:41

Hi,

Thanks for the info. One more thing....I am in rpm hell. When I try to
# rpm -Uvh postgresql-libs-8.2.3-1PGDG.i686.rpm
I get:
error: Failed dependencies:
        libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386
        libpq.so.3 is needed by (installed) postgresql-python-7.4.13-2.RHEL4.1.i386
        libpq.so.3 is needed by (installed) php-pgsql-4.3.9-3.15.i386
and when I try:
# rpm -ivh compat-postgresql-libs-3-3PGDG.i686.rpm
I get:
error: Failed dependencies:
        postgresql-libs < 8.0.2 conflicts with compat-postgresql-libs-3-3PGDG.i686
grrrrr...
should just force the upgrade (ie. --nodeps)?

Thanks

Mike

On 4/10/07, Devrim GÜNDÜZ <devrim@commandprompt.com> wrote:

Hi,

On Tue, 2007-04-10 at 22:55 +0200, Guillaume Smet wrote:
> See http://developer.postgresql.org/~devrim/rpms/compat/ and choose
> the correct package for your architecture.

... or better, each RHEL4 directory in our FTP site has compat package
(that directory is not up2date now).

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/

Re: Do I need to rebuild php-pgsql for 8.2.3

From

"Adam Rich"

Date:

11 April 2007, 17:53:48

Here's what I do...

1) Install postgresql-libs from the RHEL source

2) Install compat-postgresql-libs from postgresql.org (install, not upgrade, use rpm -hiv) use force if necessary

3) Install postgresq-libs from postgresql.org (again, install, not upgrade, use rpm-hiv) use force if necessary

If done correctly, you'll end up with all 3 client versions:

/usr/lib/libpq.so.3

/usr/lib/libpq.so.4

/usr/lib/libpq.so.5

-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Michael Dengler
Sent: Wednesday, April 11, 2007 12:25 PM
To: Devrim GÜNDÜZ
Cc: pgsql-performance; Guillaume Smet
Subject: Re: [PERFORM] Do I need to rebuild php-pgsql for 8.2.3

Hi,

Thanks for the info. One more thing....I am in rpm hell. When I try to
# rpm -Uvh postgresql-libs-8.2.3-1PGDG.i686.rpm
I get:
error: Failed dependencies:
        libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386
        libpq.so.3 is needed by (installed) postgresql-python-7.4.13-2.RHEL4.1.i386
        libpq.so.3 is needed by (installed) php-pgsql-4.3.9-3.15.i386
and when I try:
# rpm -ivh compat-postgresql-libs-3-3PGDG.i686.rpm
I get:
error: Failed dependencies:
        postgresql-libs < 8.0.2 conflicts with compat-postgresql-libs-3-3PGDG.i686
grrrrr...
should just force the upgrade (ie. --nodeps)?

Thanks

Mike

On 4/10/07, Devrim GÜNDÜZ <devrim@commandprompt.com> wrote:
Hi,

On Tue, 2007-04-10 at 22:55 +0200, Guillaume Smet wrote:
> See http://developer.postgresql.org/~devrim/rpms/compat/ and choose
> the correct package for your architecture.

... or better, each RHEL4 directory in our FTP site has compat package
(that directory is not up2date now).

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/

Re: Do I need to rebuild php-pgsql for 8.2.3

From

Devrim GÜNDÜZ

Date:

11 April 2007, 18:12:28

Hi,

On Wed, 2007-04-11 at 13:25 -0400, Michael Dengler wrote:

> Thanks for the info. One more thing....I am in rpm hell. When I try
> to
> # rpm -Uvh postgresql-libs-8.2.3-1PGDG.i686.rpm
> I get:
> error: Failed dependencies:
>         libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386
>         libpq.so.3 is needed by (installed)
> postgresql-python-7.4.13-2.RHEL4.1.i386
>         libpq.so.3 is needed by (installed) php-pgsql-4.3.9-3.15.i386
> and when I try:
> # rpm -ivh compat-postgresql-libs-3-3PGDG.i686.rpm
> I get:
> error: Failed dependencies:
>         postgresql-libs < 8.0.2 conflicts with
> compat-postgresql-libs-3-3PGDG.i686

It seems that you already have PostgreSQL installed on your server. Tı
install 8.2.3:

* Take a dump using pg_dump(all).

* Remove existing RPMS, ignore warnings about libpq.so*

* Install compat-3 package

* Install 8.2.3 packages.

* Reload your dump.

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/

Attachment

signature.asc

Re: Do I need to rebuild php-pgsql for 8.2.3

From

"Michael Dengler"

Date:

11 April 2007, 21:47:55

Thanks...worked perfectly!

Mike

On 4/11/07, Adam Rich <adam.r@sbcglobal.net> wrote:

Here's what I do...

1) Install postgresql-libs from the RHEL source
2) Install compat-postgresql-libs from postgresql.org (install, not upgrade, use rpm -hiv) use force if necessary
3) Install postgresq-libs from postgresql.org (again, install, not upgrade, use rpm-hiv) use force if necessary

If done correctly, you'll end up with all 3 client versions:

/usr/lib/libpq.so.3
/usr/lib/libpq.so.4
/usr/lib/libpq.so.5

-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Michael Dengler
Sent: Wednesday, April 11, 2007 12:25 PM
To: Devrim GÜNDÜZ
Cc: pgsql-performance; Guillaume Smet
Subject: Re: [PERFORM] Do I need to rebuild php-pgsql for 8.2.3

Hi,

Thanks for the info. One more thing....I am in rpm hell. When I try to
# rpm -Uvh postgresql-libs-8.2.3-1PGDG.i686.rpm
I get:
error: Failed dependencies:
        libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386
        libpq.so.3 is needed by (installed) postgresql-python-7.4.13-2.RHEL4.1.i386
        libpq.so.3 is needed by (installed) php-pgsql-4.3.9-3.15.i386
and when I try:
# rpm -ivh compat-postgresql-libs-3-3PGDG.i686.rpm
I get:
error: Failed dependencies:
        postgresql-libs < 8.0.2 conflicts with compat-postgresql-libs-3-3PGDG.i686
grrrrr...
should just force the upgrade (ie. --nodeps)?

Thanks

Mike

On 4/10/07, Devrim GÜNDÜZ <devrim@commandprompt.com> wrote:
Hi,

On Tue, 2007-04-10 at 22:55 +0200, Guillaume Smet wrote:
> See http://developer.postgresql.org/~devrim/rpms/compat/ and choose
> the correct package for your architecture.

... or better, each RHEL4 directory in our FTP site has compat package
(that directory is not up2date now).

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/