Re: RE: RE: Win95 PostGreSQL

"Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)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

> Hope this helps,
> - Stuart
>  
>
> > -----Original Message-----
> > From: Andrew [SMTP:andrewy(at)rnd(dot)celcom(dot)com(dot)my]
> > Sent: Wednesday, June 20, 2001 7:46 AM
> > To:   'pgsql-cygwin(at)postgresql(dot)org'
> > Subject:  [CYGWIN] RE: Win95 PostGreSQL
> >
> > Hello,
> >
> > I have just installed the CygWin, latest version. And I tried to use the
> > createdb and psql,
> > Both have the below error. Can someone help me on this error, I am newbie
> > to these stuff.
> > Thanks.
> >
> > Andrew.
> >
> > =========================
> >
> > $ createdb -p 5000 -h godnukem -e demo
> > psql: connectDBStart() -- connect() failed: Connection refused
> >         Is the postmaster running (with -i) at 'godnukem'
> >         and accepting connections on TCP/IP port 5000?
> > createdb: database creation failed
> >
> > andrew(at)STATION01 /bin
> > $ createdb test
> > psql: connectDBStart() -- connect() failed: No such file or directory
> >         Is the postmaster running locally
> >         and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> > createdb: database creation failed
> >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

SLao
__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/