Sam Mason <sam@samason.me.uk> writes:
> On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote:
>> An easy trick I have found to set postgres password: $ sudo passwd
>> postgres, and now you can type a new password. So now you can switch
>> user with: $ su postgres, and then connect to the DB with psql.
> Won't that allow logins to the postgres account then?
True, but that might be safer overall than giving out sudo privileges.
If the sysadmin and the DBA are the same person it hardly matters,
but if you want the DBA to not have root, then giving him a password for
the postgres account is the best way. So it all depends on your
local situation ...
regards, tom lane