On Wed, Jun 3, 2009 at 8:32 PM, Seb <splu...@gmail.com> wrote: >> It may be easier to drop the schema altogether, grant your user >> account access to the postgres database, and then re-create the >> pgagent schema using your user account. > > Yes, this sounds simpler at this point, although I'm not sure what > privileges to grant myself to the postgres database? I assume this > needs to be done while logged in as the postgres user (i.e. after 'su - > postgres; psql postgres'). Thanks.
Yes, log in as postgres. GRANT CREATE ON DATABASE postgres TO myuser; should be enough. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
