pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDo I need to rebuild php-pgsql for 8.2.3
7+ messages / 4 participants
[nested] [flat]
* Do I need to rebuild php-pgsql for 8.2.3
@ 2007-04-10 19:44 Michael Dengler <michael.dengler@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Michael Dengler @ 2007-04-10 19:44 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Do I need to rebuild php-pgsql for 8.2.3
@ 2007-04-10 20:55 Guillaume Smet <guillaume.smet@gmail.com>
parent: Michael Dengler <michael.dengler@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Guillaume Smet @ 2007-04-10 20:55 UTC (permalink / raw)
To: Michael Dengler <michael.dengler@gmail.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Do I need to rebuild php-pgsql for 8.2.3
@ 2007-04-10 21:01 Devrim GÜNDÜZ <devrim@CommandPrompt.com>
parent: Guillaume Smet <guillaume.smet@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Devrim GÜNDÜZ @ 2007-04-10 21:01 UTC (permalink / raw)
To: Michael Dengler <michael.dengler@gmail.com>; +Cc: pgsql-performance; Guillaume Smet <guillaume.smet@gmail.com>
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/
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Do I need to rebuild php-pgsql for 8.2.3
@ 2007-04-11 17:25 Michael Dengler <michael.dengler@gmail.com>
parent: Devrim GÜNDÜZ <devrim@CommandPrompt.com>
0 siblings, 2 replies; 7+ messages in thread
From: Michael Dengler @ 2007-04-11 17:25 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@commandprompt.com>; +Cc: pgsql-performance; Guillaume Smet <guillaume.smet@gmail.com>
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/
>
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Do I need to rebuild php-pgsql for 8.2.3
@ 2007-04-11 17:53 Adam Rich <adam.r@sbcglobal.net>
parent: Michael Dengler <michael.dengler@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Adam Rich @ 2007-04-11 17:53 UTC (permalink / raw)
To: 'Michael Dengler' <michael.dengler@gmail.com>; 'Devrim GÜNDÜZ' <devrim@commandprompt.com>; +Cc: pgsql-performance; 'Guillaume Smet' <guillaume.smet@gmail.com>
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/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Do I need to rebuild php-pgsql for 8.2.3
@ 2007-04-11 18:12 Devrim GÜNDÜZ <devrim@CommandPrompt.com>
parent: Michael Dengler <michael.dengler@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Devrim GÜNDÜZ @ 2007-04-11 18:12 UTC (permalink / raw)
To: Michael Dengler <michael.dengler@gmail.com>; +Cc: pgsql-performance; Guillaume Smet <guillaume.smet@gmail.com>
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/
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Do I need to rebuild php-pgsql for 8.2.3
@ 2007-04-11 21:47 Michael Dengler <michael.dengler@gmail.com>
parent: Adam Rich <adam.r@sbcglobal.net>
0 siblings, 0 replies; 7+ messages in thread
From: Michael Dengler @ 2007-04-11 21:47 UTC (permalink / raw)
To: Adam Rich <adam.r@sbcglobal.net>; +Cc: Devrim GÜNDÜZ <devrim@commandprompt.com>; pgsql-performance; Guillaume Smet <guillaume.smet@gmail.com>
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/<http://developer.postgresql.org/%7Edevrim/rp... 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/
> >
> >
> >
> >
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2007-04-11 21:47 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-10 19:44 Do I need to rebuild php-pgsql for 8.2.3 Michael Dengler <michael.dengler@gmail.com>
2007-04-10 20:55 ` Guillaume Smet <guillaume.smet@gmail.com>
2007-04-10 21:01 ` Devrim GÜNDÜZ <devrim@CommandPrompt.com>
2007-04-11 17:25 ` Michael Dengler <michael.dengler@gmail.com>
2007-04-11 17:53 ` Adam Rich <adam.r@sbcglobal.net>
2007-04-11 21:47 ` Michael Dengler <michael.dengler@gmail.com>
2007-04-11 18:12 ` Devrim GÜNDÜZ <devrim@CommandPrompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox