Re: vacuum all but system tables - Mailing list pgsql-sql

From A.Bhuvaneswaran
Subject Re: vacuum all but system tables
Date
Msg-id Pine.LNX.4.44.0303191856010.2487-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to vacuum all but system tables  ("Victor Yegorov" <viy@pirmabanka.lv>)
List 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



pgsql-sql by date:

Previous
From: "Sjors"
Date:
Subject: Re: howto/min values
Next
From: Christoph Haller
Date:
Subject: Re: howto/min values