Thankyou! That worked, much easier than dumping the db..
thanks
Anders
On Monday, December 9, 2002, at 09:35 AM, Tom Lane wrote:
Anders Bogdan <[EMAIL PROTECTED]> writes:
I've created and deployed a number of databases and am now getting
around to adding some table maintenance (a vacuum script). But, the
script can't run as the "postgres" user. It runs as a defined db user
"admin".. Unfortunately, in my db schema the tables are owned by
postgres and my script doesn't have permission to vacuum.
Make "admin" a postgres superuser. (I think "ALTER USER admin
CREATEUSER"
is the approved way to do this.)
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
