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.)
regards, tom lane