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(at)gulliver pgsql]$ mkdir /usr/local/pgsql/data
[chauser(at)gulliver pgsql]$ sudo chown chauser /usr/local/pgsql/data
[chauser(at)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(at)appl-ecosys(dot)com
> http://www.appl-ecosys.com/
>