Re: workaround steps for autovaccum problem

If you are not willing to do a minor upgrade, it is unlikely many people
are going to be willing to take the time to entertain your questions.

---------------------------------------------------------------------------

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  or I can skip this step.
>
> For your reference I am again updating the scenario :
>
> Autovacuum is getting invoked after every 5 mins and vacuums all the
> database turn by turn and every database is getting its turn of
> autovaccum after every 20 mins as there are 4 databases (template0 ,
> template1, postgres and abc(my database) ).
>
>
> Now suppose , this autovacuum problem occurs and through some script its
> detected immediately at the very onset of the problem and below
> mentioned workaround steps are executed
>
> 1. Stop postgres
> 2. create 256K zero filled  0C01 file in /var/lib/pgsql/data/pg_clog
> folder.
> 3. Start postgres
>
> Then still , do I need to execute 'vacuum freeze' on all databases ??
> Because, my databases were already getting autovacuumed properly before
> the problem , the problem was resolved as soon as it occurred within let
> say 2 mins and after the problem is resolved 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:david@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 problem
>
> 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 <david@fetter.org> http://fetter.org/
> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
> Skype: davidfetter      XMPP: david.fetter@gmail.com
> iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +