Re: postgres database user account

Yes, you can create a role that is a superuser that should be able to do internal work:

CREATE ROLE myuser;
ALTER ROLE myuser WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'mypassword' VALID UNTIL 'infinity';

If you are talking about the operating system account named postgres, then this is a different question.

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Maria L. Wilson
Sent: Wednesday, June 30, 2010 2:15 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] postgres database user account

Hoping someone out there can answer this general question(s).... I am
having to justify having access to the "postgres" database user account
to do DBA type work.....
Is there any specific items that require the postgres database user
account to run?

Can any general user (with superuser permission) basically do what this
postgres account does?

thanks, Maria Wilson
Nasa/Langley Research Center
Hampton, Virginia 23681