sorry for the confusion - from what the docs - i am starting out the
single user like this.....
postgres --single -D /data/pg_devices postgres
*that connects me to the "postgres" database
postgres --single -D /data/pg_devices n001acs
*that connects me to the "n001acs" database.......
then I am issuing a vacuum command with each session..... Sound okay?
Scott Marlowe wrote:
On Mon, Apr 20, 2009 at 12:43 PM, Maria L. Wilson
<maria.l.wilso...@nasa.gov> wrote:
ouch!! ok - this may take me all week!
i'm opening each database when I start up the server ( postgres --single -D
/data/pg_devices /database1/ )
This is not specifying the db to connect to. You need:
postgres --single -D /data/pg_devices /database1/ postgres
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
