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 <anders@theworks.org> 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.)