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@xxxxxxxxxx] > Sent: Wednesday, September 15, 2010 3:27 AM > To: tamanna madaan > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxx> http://fetter.org/ > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter > Skype: davidfetter XMPP: david.fetter@xxxxxxxxx > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
