On 11 Mar 2003, Charles Hauser wrote:
> Is it advisable/required to:
> - create a 'postgres' user account which owns /data
> - and then create user 'chauser' as owner of a specific DB?
My understanding is that postgresql installs expecting a user 'postgres'
as its admin. What I've done in the past is install postgresql then, as
root, use adduser/useradd to create the 'postgres' user account.
Once I have postgres living here I 'su postgres' (from my username
account), start postgresql (with psql), then issue the command, 'createuser
<username> -c -u'. This creates my username as a superuser able to create
new databases and new users. Then I usually forget the password for the
'postgres' user because I do all the admin tasks as me. :-)
Make sense?
HTH,
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com
http://www.appl-ecosys.com/