Re: Installation question

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/