Re: [GENERAL] 8.3.0 upgrade

2008-03-21 Thread Devrim GÜNDÜZ
Hi, On Fri, 2008-03-21 at 14:37 -0500, Adam Rich wrote: > I have applications that depend on libpq.so.4 > > Where do I get that, if not compat-postgresql-libs-4-2 ?? I'll send you instructions for how to build custom compat package. Regards, -- Devrim GÜNDÜZ , RHCE PostgreSQL Replication, Cons

Re: [GENERAL] 8.3.0 upgrade

2008-03-21 Thread Adam Rich
> No, you need compat-3, not compat-4. For example: > > [EMAIL PROTECTED] ~]# yum install php-pgsql > --> Processing Dependency: libpq.so.3 for package: php-pgsql I have applications that depend on libpq.so.4 Where do I get that, if not compat-postgresql-libs-4-2 ?? -- Sent via pgsql-general

Re: [GENERAL] 8.3.0 upgrade

2008-03-21 Thread Devrim GÜNDÜZ
Hi, On Fri, 2008-03-21 at 14:13 -0500, Adam Rich wrote: > I clicked on my OS (RHEL/CentOS 4 - x86) Then on "C" as you said, > But the RPM list still only contains the compat-postgresql-libs-3-2 > package, when I'm looking for compat-postgresql-libs-4-2 No, you need compat-3, not compat-4. For exa

Re: [GENERAL] 8.3.0 upgrade

2008-03-21 Thread Adam Rich
> Pick your OS/Arch from this list, and click to it: > > http://yum.pgsqlrpms.org/rpmchart.php > > Then click to "C" at the top, and download the compat package. Devrim, I clicked on my OS (RHEL/CentOS 4 - x86) Then on "C" as you said, But the RPM list still only contains the compat-postgresql-l

Re: [GENERAL] 8.3.0 upgrade

2008-03-18 Thread Devrim GÜNDÜZ
Hi, On Mon, 2008-03-17 at 21:26 -0500, Adam Rich wrote: > Next, one of my apps failed because of a dependency on libpq.so.4. > During previous upgrades, I remedied that by installing this package: > > compat-postgresql-libs-4-2PGDG.rhel4 > > But it seems under the 8.3.0 binary downloads, th

Re: [GENERAL] 8.3.0 upgrade

2008-03-17 Thread Adam Rich
Thanks to Pavan for the answer regarding HOT. Does anybody have an answer regarding the postgres role or compat lib ? > > * From: "Adam Rich" > * To: > * Subject: 8.3.0 upgrade > * Date: Mon, 17 Mar 2008 02:13:55 -0500 > > > I just finished upgrading my production DB to 8

Re: [GENERAL] 8.3.0 upgrade

2008-03-17 Thread Pavan Deolasee
On Mon, Mar 17, 2008 at 12:43 PM, Adam Rich <[EMAIL PROTECTED]> wrote: > > Finally, regarding the new "HOT" feature. The release notes say that > benefits are realized "if no changes are made to indexed columns". > If my updates include *all columns* (the SQL is generated dynamically) > but t

[GENERAL] 8.3.0 upgrade

2008-03-17 Thread Adam Rich
I just finished upgrading my production DB to 8.3.0. Everything went smoothly, but I thought of a few questions. After the upgrade, while restoring my backup to the new version, I got this error message: ERROR: role "postgres" already exists I assume this is nothing to be concerned about. B