I'm working with a client with several highly active 8.1.4 servers. I want to
run a weekly cron that will vacuum ALL db tables except those with entries in
pg_autovacuum (where we've setup manual/cron vacuums) in order to eliminate
transaction ID wraparound failure warnings (which comes up fairly often).
My question is:
will a select from pg_tables for each database in the cluster provide me with
a full table listing for the purposes of ensuring that all tables in the db
have been vacuumed or are there others I'll need to account for as well ?
Thanks in advance...
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2007-11-19 23:29:15|
|Subject: Re: Get a list of ALL tables |
|Previous:||From: Magnus Hagander||Date: 2007-11-19 17:20:20|
|Subject: Re: [GENERAL] Error while starting postgreSQL service|