Re: pgagent in Debian sid

On Wed, Jun 3, 2009 at 8:32 PM, Seb <spluque@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