Re: postgres
On Thu, Aug 26, 1999 at 11:55:14AM +0100, rnewton3@csc.com wrote
> Hallo all,
> I've just installed the postgres stuff ok, but I thought I'd check out
> a thought before I upset something.
> I understand that user 'postgres' is the dba for postgres. It is user
> postgres who adds and deletes users and
> databases. Is it safe to change the password for user postgres? At the
> moment I can only access the user by su'ing from root, is this the accepted
> way of doing it?
> Suggestions please.
> I'd appreciate a cc as well 'cos I'm not at home at the moment. Thanks
>
postgres is the user that owns the postgres data files, and the user that
the postmaster is run as (much as www-data is for apache). A better plan is
to su to postgres only to make your human dba's username a postgres user,
and give him the ability to create users and databases. It would be best if
the user postgres had an invalid password (*), like ftp and mail do.
John P.
--
huiac@camtech.net.au
john@huiac.apana.org.au
"Oh - I - you know - my job is to fear everything." - Bill Gates in Denmark
Reply to: