Thanks Scott for your reply ...
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Wednesday, September 15, 2010 7:36 AM
To: tamanna madaan
Cc: David Fetter; pgsql-general@postgresql.org
Subject: Re: [GENERAL] workaround steps for autovaccum problem
On Tue
On Tue, Sep 14, 2010 at 6:00 PM, tamanna madaan
wrote:
> I know upgrading postgres will resolve the problem permanently .
> But I wanted some workaround for now before I actually upgrade.
> But let me know if I really need to execute `vacuum freeze`
> In the scenario given in my previous update o
On Tue, 2010-09-14 at 17:01 -0700, David Fetter wrote:
> On Wed, Sep 15, 2010 at 05:30:51AM +0530, tamanna madaan wrote:
> > I know upgrading postgres will resolve the problem permanently .
> > But I wanted some workaround for now before I actually upgrade.
>
> I want a pony, but I'm not getting o
solved by workaround steps, then
> autovacuum will start vacuuming all the 4 databases every 20 mins as
> I mentioned above.
>
> Please confirm ...
>
> -Original Message-
> From: David Fetter [mailto:da...@fetter.org]
> Sent: Wednesday, September 15, 2010 3:27 AM
databases every 20 mins as
I mentioned above.
Please confirm ...
-Original Message-
From: David Fetter [mailto:da...@fetter.org]
Sent: Wednesday, September 15, 2010 3:27 AM
To: tamanna madaan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] workaround steps for autovaccum probl
On Wed, Sep 15, 2010 at 05:30:51AM +0530, tamanna madaan wrote:
> I know upgrading postgres will resolve the problem permanently .
> But I wanted some workaround for now before I actually upgrade.
I want a pony, but I'm not getting one. Upgrade PostgreSQL :)
Cheers,
David.
--
David Fetter http
On Wed, Sep 15, 2010 at 02:39:26AM +0530, tamanna madaan wrote:
> Hi All
>
>
>
> I am using postgres-8.1.2. I am getting the following error while
> autovacuum.
Please upgrade your software to PostgreSQL 8.1.21 and try again.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 2
Hi All
I am using postgres-8.1.2. I am getting the following error while
autovacuum.
2010-08-18 18:36:14 UTC LOG: autovacuum: processing database "template0"
2010-08-18 18:36:14 UTC ERROR: could not access status of transaction
3222599682
2010-08-18 18:36:14 UTC DETAIL: could not open file
