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-libs-3-2

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

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 snip -- 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: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,

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

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

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

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 adam(dot)r(at)sbcglobal(dot)net * To: pgsql-general(at)postgresql(dot)org * Subject: 8.3.0 upgrade * Date: Mon, 17 Mar 2008 02:13:55