What you've done will work fine. If you don't have root access on the box
and can't create accounts, running it under your own account is fine.
Just know that the database, running something like an untrusted pl
language, could be used by other database users to snoop around in your
personal directory and everything.
On 11 Mar 2003, Charles Hauser wrote:
> 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/
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>