Re: Installation question

Richard,

Apologize for being dense....

Is it advisable/required to:
    - create a 'postgres' user account which owns /data
    - and then create user 'chauser' as owner of a specific DB?


what I did yesterday was to:

[chauser@gulliver pgsql]$ mkdir /usr/local/pgsql/data
[chauser@gulliver pgsql]$ sudo chown chauser /usr/local/pgsql/data
[chauser@gulliver pgsql]$  /usr/local/pgsql/bin/initdb -D
/usr/local/pgsql/data
The files belonging to this database system will be owned by user
"chauser".
This user must also own the server process.
.....

I am not root, and can not 'adduser postgres' (sudo will not work?)

But from what I am reading I should make user 'postgres' own /data


Charles

> > Perhaps, first time install...........
> >
> > ./configure    -> ran OK
> > gmake        -> ran OK
> > su        -> I misunderstood and did NOT do this
> > gmake install    -> sudo gmake install  ran OK
> >
> > So, I want to:
> >     - create a DB with me as owner
> >
> > adduser postgres-> skip?
>
>   Beg pardon, Charles. I thought you had the postgres user added already.
> What I've done in the past -- and this may be different with the 7.3 series
> -- is su to postgres to run initdb, then create me as a user.
>
> 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/
>