I started this about a few hours ago (I guess the message shows as a general warning)..I am only interested in the specific database..will this command NOT do a full vacuum of the specific database(I would like to save the few hours that I invested in this vacuum command if possible) -----Original Message----- From: Scott Marlowe [mailto:smarlowe@xxxxxxxxxxxxxxxxx] Sent: Wednesday, September 06, 2006 10:35 AM To: Sriram Dandapani Cc: Tom Lane; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] transactoin id wraparound problem Change the -f to -a On Wed, 2006-09-06 at 11:02, Sriram Dandapani wrote: > I created a super user using the createuser command and issued > > vacuumdb -f -U superuser <database-name> > > I still keep getting a decreasing transaction count warning. Am I doing > something wrong here.(The database is about 120G and while I do expect > vacuum full to take time, I expect the warning to show an increasing > count)