Thread: RE: RE: RE: Win95 PostGreSQL

RE: RE: RE: Win95 PostGreSQL

From
"Henshall, Stuart - WCP"
Date:
oops, my mistake. Thanks for the correction. As to -h <hostname> I can
connect to the local postmaster with out it (from psql, etc...).
- Stuart

> -----Original Message-----
> From:    s0lao@netscape.net [SMTP:s0lao@netscape.net]
> Sent:    Wednesday, June 20, 2001 9:55 AM
> To:    SHenshall@westcountrypublications.co.uk
> Cc:    andrewy@rnd.celcom.com.my; pgsql-cygwin@postgresql.org
> Subject:    Re: RE: [CYGWIN] RE: Win95 PostGreSQL
>
>
> "Henshall, Stuart - WCP" <SHenshall@westcountrypublications.co.uk> wrote:
> >
> > Hello,
> >     It looks like you need to initdb. If you have PGDATA in the
> > enviroment then all you need do is initd. If you need to specify the
> data
> > directory then use -D
> > (eg: initdb -D /var/pgsql/data ).
> >     You then need to start the ipc-daemon with ipc-daemon & and then the
> > postmaster with something like postmaster -i &
>
> Actually the order is a bit different:
> 1. Start first of all ipc-daemon with "ipc-daemon &"
> 2. If you didn't, do a simple "initdb" -- the best ideea is to set
> environment variables required by PostgreSQL utilities (i.e. psql & co.),
> not to use the "-D" switch for each of them
> 3. Start the postmaster having "-i" option enabled -- either "postmaster
> -i&" or "pg_ctl -o \"-i"\ start"
> 4. Play with whaterver utility you wish -- never forget to use "-h
> <hostname>" option -- under win32 it's required
>
>