From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: transactoin id wraparound problem |
Date: | 2006-09-06 17:31:02 |
Message-ID: | 20060906173101.GG362@phlogiston.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, Sep 06, 2006 at 06:53:28AM -0700, Sriram Dandapani wrote:
> Do you mean that I login as say root and issue a vacuumdb (or do I login
> as a postgres user with special privileges)
Probably you want
vacuumdb -U postgres -a
The -a tells it to do all databases, and the -U postgres tells it to
connect as the postgresql superuser. If your superuser is something
other than postgres (sometimes it is -- pgsql for instance -- but
rarely), you should use that username instead. This is the
_database_ user name, not the UNIX username (which is what root would
be). You'll need the (postgresql) password for the account in
question to do this.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2006-09-06 17:33:31 | Re: transactoin id wraparound problem |
Previous Message | Matthew O'Connor | 2006-09-06 17:25:51 | Re: transactoin id wraparound problem |