latest is 8.3.21 according to postgresql.org. On Tue, Nov 27, 2012 at 10:05 PM, <subhasis.bhattacharya@xxxxxxxxx> wrote: > Hi Scott, > > Thanks for ur reply. BTW I thought 8.3.14 was the latest in the 8.3 series...no? > > > ------Original Message------ > From: Scott Marlowe > To: Subhasis Bhattacharya > Cc: Craig Ringer > Cc: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?) > Sent: Nov 28, 2012 4:55 AM > > On Sat, Nov 24, 2012 at 7:25 AM, Subhasis Bhattacharya > <subhasis.bhattacharya@xxxxxxxxx> wrote: >> Thanks Craig, >> >> We have plans to upgrade to a later version of postgres, but that could take >> a while. >> >> Meantime, I wanted to understand whether the autovacuum failure could be >> linked to the fact that the stats collector could not update (rename) the >> pgstats file? > > It's important to understand that Craig is implying you're getting > bitten by a bug in an early version of pg 8.3 that can be fixed by > updating to a later version of pg 8.3. Updating within a minor > version number like that causes minimum down time as it simply copies > in new binary files and restarts the db with no need for upgrading the > /data directory. On most debian based boxes it's as simple as: > > sudo apt-get update > or > sudo apt-get upgrade > > > Sent from BlackBerry® on Airtel -- To understand recursion, one must first understand recursion. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
