If you do:
chown -R <username> data
to wherever you put the data directory (eg /usr/local/pgsql) then this
should change ownership to the user specified (IIRC). However I believe it
is currently advised to setup as root (I'm not sure on this though so best
to check).
It is advised to actually run the postmaster as an unprivilidged user so
that if someone manages to run abitery code through perlu or something then
the damage will be limited.
To create a cygwin user create a user in windows then execute mkpasswd -l
>/etc/passwd from the bash command line IIRC.
- Stuart
> -----Original Message-----
> From: Anil Jangam [SMTP:anilj@indts.com]
> Sent: Tuesday, October 16, 2001 12:12 PM
> To: 'Henshall, Stuart - WCP'; 'pgsql-cygwin@postgresql.org'
> Subject: RE: [CYGWIN] useradd OR adduser commands
>
> hi,
>
> I am trying to create a user which is a OS user account and not the
> database
> user acccout.
> This is as mentioned in the "3.2. Creating a database cluster" document.
>
> > initdb -D /usr/local/pgsql/data
> Note that you must execute this command while being logged in to the
> Postgres user account, which is described in the previous section. This
> (Postgres) is the user we need to create to install the database. Also the
> this is the user space created in the Unix shell.
>
> There is infact the command which you have mentioed, which creates the
> database user and not the OS user. The useradd OR adduser creates a
> seperate
> space other than administrator/root user.
>
> I am not sure if I initialize the database within administrator/root,
> there
> is any impact/disadvantage of doing so.
>
> -Anil.
>
>
> > -----Original Message-----
> > From: Henshall, Stuart - WCP
> > [mailto:SHenshall@westcountrypublications.co.uk]
> > Sent: Tuesday, October 16, 2001 3:49 PM
> > To: 'Anil Jangam'; 'pgsql-cygwin@postgresql.org'
> > Subject: RE: [CYGWIN] useradd OR adduser commands
> >
> >
> > Try createuser (or use create user in psql)
> > - Stuart
> >
> > > -----Original Message-----
> > > From: Anil Jangam [SMTP:anilj@indts.com]
> > > Sent: Tuesday, October 16, 2001 8:50 AM
> > > To: 'pgsql-cygwin@postgresql.org'
> > > Subject: [CYGWIN] useradd OR adduser commands
> > >
> > > Hi,
> > >
> > > The commands useradd OR adduser are not available under the
> > postgreSQL
> > > 7.1.2.
> > > It gives the 'command not found' error. Does 7.1.2 setup
> > contains these
> > > commands??
> > >
> > > -anil.
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> > > http://archives.postgresql.org
> >