Re: [GENERAL] error while autovacuuming

2010-10-03 Thread Gurjeet Singh
On Fri, Oct 1, 2010 at 9:16 PM, Craig Ringer wrote: > On 2/10/2010 5:44 AM, Scott Marlowe wrote: > >> On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan >> wrote: >> >>> Hi All >>> >>> I am planning to upgrade postgres to avoid this autovacuum problem. >>> >>> From the release notes of postgres-8.

Re: [GENERAL] error while autovacuuming

2010-10-01 Thread Craig Ringer
On 2/10/2010 5:44 AM, Scott Marlowe wrote: On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan wrote: Hi All I am planning to upgrade postgres to avoid this autovacuum problem. From the release notes of postgres-8.1.x it seems this issue has been solved in postgres-8.1.6 and hence upgrading to

Re: [GENERAL] error while autovacuuming

2010-10-01 Thread tamanna madaan
Thanks a lot Scott ... -Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Saturday, October 02, 2010 3:14 AM To: tamanna madaan Cc: Michael Glaesemann; pgsql-general@postgresql.org Subject: Re: [GENERAL] error while autovacuuming On Fri, Oct 1, 2010 at 2:06

Re: [GENERAL] error while autovacuuming

2010-10-01 Thread Scott Marlowe
On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan wrote: > Hi All > > I am planning to upgrade  postgres to avoid this autovacuum problem. > > From the release notes of postgres-8.1.x it seems this issue > has been solved in postgres-8.1.6 and hence upgrading > to latest 8.1 release i.e 8.1.21 will s

Re: [GENERAL] error while autovacuuming

2010-10-01 Thread tamanna madaan
.. Thanks... Tamanna -Original Message- From: tamanna madaan Sent: Thursday, September 09, 2010 7:25 PM To: 'Michael Glaesemann'; 'Scott Marlowe' Cc: 'pgsql-general@postgresql.org' Subject: RE: [GENERAL] error while autovacuuming Hi All Can I upgrade dir

Re: [GENERAL] error while autovacuuming

2010-09-09 Thread Craig Ringer
On 09/10/2010 05:05 AM, tamanna madaan wrote: Hi David You mean to say , change the binary to postgres-8.1.21 and then restart postgres . that's it ?? please confirm.. Strictly, you should install the whole of PostgreSQL 8.1.21, replacing your old installation of the older version. Replacin

Re: [GENERAL] error while autovacuuming

2010-09-09 Thread tamanna madaan
Ok . Thanks .. -Original Message- From: David Fetter [mailto:da...@fetter.org] Sent: Friday, September 10, 2010 2:36 AM To: tamanna madaan Cc: Scott Marlowe; pgsql-general@postgresql.org Subject: Re: [GENERAL] error while autovacuuming On Fri, Sep 10, 2010 at 02:35:29AM +0530, tamanna

Re: [GENERAL] error while autovacuuming

2010-09-09 Thread David Fetter
On Fri, Sep 10, 2010 at 02:35:29AM +0530, tamanna madaan wrote: > Hi David > > You mean to say , change the binary to postgres-8.1.21 and then restart > postgres . that's it ?? please confirm.. Yes. :) Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Y

Re: [GENERAL] error while autovacuuming

2010-09-09 Thread tamanna madaan
rlowe; pgsql-general@postgresql.org Subject: Re: [GENERAL] error while autovacuuming On Fri, Sep 10, 2010 at 12:53:10AM +0530, tamanna madaan wrote: > Hi Scott > > Sorry to bug you again. > > I know that upgrading to postgres-8.1.21 will be my best bet. But I > have my own limitat

Re: [GENERAL] error while autovacuuming

2010-09-09 Thread David Fetter
On Fri, Sep 10, 2010 at 12:53:10AM +0530, tamanna madaan wrote: > Hi Scott > > Sorry to bug you again. > > I know that upgrading to postgres-8.1.21 will be my best bet. But I > have my own limitations because of which I just want to apply a > patch with a single fix which is for autovacuum error

Re: [GENERAL] error while autovacuuming

2010-09-09 Thread tamanna madaan
NERAL] error while autovacuuming On Wed, Sep 8, 2010 at 1:11 PM, tamanna madaan wrote: > > > Hi All > > Can a postgres patch for the fix ( provided in postgres-8.1.6 for > autovacuum error ) be included with the postgres version I am using i.e > postgres 8.1.2 so that I don&#

Re: [GENERAL] error while autovacuuming

2010-09-09 Thread Alvaro Herrera
Excerpts from tamanna madaan's message of jue sep 09 09:55:01 -0400 2010: > Hi All > > Can I upgrade directly to postgres-8.4 . I think it would also be having > the fix for "autovacuum error" which is there in postgres-8.1.6 . But > please confirm . An upgrade to 8.4 is going to be much more com

Re: [GENERAL] error while autovacuuming

2010-09-09 Thread tamanna madaan
: 'Michael Glaesemann'; Scott Marlowe Cc: pgsql-general@postgresql.org Subject: RE: [GENERAL] error while autovacuuming Hi All Thanks for your reply . Actually, I have a cluster setup with two nodes in it. I am having postgres-8.1.2 and am using slony-1.1.5 for replication between two n

Re: [GENERAL] error while autovacuuming

2010-09-08 Thread Alvaro Herrera
Excerpts from tamanna madaan's message of mié sep 08 17:10:23 -0400 2010: > Actually, I have a cluster setup with two nodes in it. I am having > postgres-8.1.2 and am using slony-1.1.5 for replication between two > nodes in that cluster. Now, If I plan to upgrade both the servers to > postgres-8

Re: [GENERAL] error while autovacuuming

2010-09-08 Thread tamanna madaan
AM To: Scott Marlowe Cc: tamanna madaan; pgsql-general@postgresql.org Subject: Re: [GENERAL] error while autovacuuming On Sep 8, 2010, at 16:15 , Scott Marlowe wrote: > On Wed, Sep 8, 2010 at 1:11 PM, tamanna madaan > wrote: >> >> >> Hi All >> >> Can a postgres

Re: [GENERAL] error while autovacuuming

2010-09-08 Thread John R Pierce
On 09/08/10 12:11 PM, tamanna madaan wrote: Hi All Can a postgres patch for the fix ( provided in postgres-8.1.6 for autovacuum error ) be included with the postgres version I am using i.e postgres 8.1.2 so that I don't have to upgrade to 8.1.21 ?? Please reply here's a few good reasons t

Re: [GENERAL] error while autovacuuming

2010-09-08 Thread Michael Glaesemann
On Sep 8, 2010, at 16:15 , Scott Marlowe wrote: > On Wed, Sep 8, 2010 at 1:11 PM, tamanna madaan > wrote: >> >> >> Hi All >> >> Can a postgres patch for the fix ( provided in postgres-8.1.6 for >> autovacuum error ) be included with the postgres version I am using i.e >> postgres 8.1.2 so tha

Re: [GENERAL] error while autovacuuming

2010-09-08 Thread Scott Marlowe
On Wed, Sep 8, 2010 at 1:11 PM, tamanna madaan wrote: > > > Hi All > > Can a postgres patch for the fix ( provided in postgres-8.1.6 for > autovacuum error ) be included with the postgres version I am using i.e > postgres 8.1.2 so that I don't have to upgrade to 8.1.21 ?? > > Please reply If you

Re: [GENERAL] error while autovacuuming

2010-09-08 Thread tamanna madaan
Hi All Can a postgres patch for the fix ( provided in postgres-8.1.6 for autovacuum error ) be included with the postgres version I am using i.e postgres 8.1.2 so that I don't have to upgrade to 8.1.21 ?? Please reply Thanks... Tamanna -Original Message- From: tamanna madaan Sent: Fr

Re: [GENERAL] error while autovacuuming

2010-08-27 Thread Alvaro Herrera
Excerpts from tamanna madaan's message of vie ago 27 05:51:16 -0400 2010: > I am using a cluster setup with two nodes in it . postgres version is 8.1.2 > and slony 1.1.5 is being used for replication. > I have autovacuum enabled. But it was giving the following error while > vacuuming template0

Re: [GENERAL] error while autovacuuming

2010-08-27 Thread Amitabh Kant
On Fri, Aug 27, 2010 at 3:21 PM, tamanna madaan < tamanna.ma...@globallogic.com> wrote: > Hi All > > Any idea about this problem ?? > > Thanks.. > Tamanna > > > -Original Message- > From: tamanna madaan > Sent: Fri 8/20/2010 11:54 AM > To: pgsql-general@postgresql.org > Subject: error whi

Re: [GENERAL] error while autovacuuming

2010-08-27 Thread tamanna madaan
Hi All Any idea about this problem ?? Thanks.. Tamanna -Original Message- From: tamanna madaan Sent: Fri 8/20/2010 11:54 AM To: pgsql-general@postgresql.org Subject: error while autovacuuming Hi All I am using a cluster setup with two nodes in it . postgres version is 8.1.2 and slon