Re: vacuum all but system tables

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Postgres SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: vacuum all but system tables
Date: 2003-03-19 13:32:56
Message-ID: Pine.LNX.4.44.0303191856010.2487-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> I'd like to make a script to automatically vacuum all my DBs nightly. And
> I'd like to skip system tables, starting with pg_*.

If you run the process as non-super user, it must skip your system tables.
On the other hand, if you run it as a super user, it must be done table
wise from your script.

regards,
bhuvaneswaran

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-03-19 13:54:03 Re: howto/min values
Previous Message Sjors 2003-03-19 13:27:43 Re: howto/min values