Vacuum and Owner - Mailing list pgsql-general

From Matt Friedman
Subject Vacuum and Owner
Date
Msg-id 004801c09590$c0bc9eb0$e8804318@mattq3h8budilr
Whole thread Raw
List pgsql-general
I run as user "spry" on psql, I created the database as "spry" but when I
run vacuum, all the system tables get skipped because "spry" is not the
owner. Is there a way to fully vacuum my db and the system tables as a user
other than "postgres"?

Is is very important that the system tables are "vaccumed" in addition to my
db tables?

Matt Friedman


pgsql-general by date:

Previous
From: "Matt Friedman"
Date:
Subject: Re: Trapping NOTICE using PHP
Next
From: DaVinci
Date:
Subject: Re: transaction safety