From: | s0lao(at)netscape(dot)net (S(dot) L(dot)) |
---|---|
To: | SHenshall(at)westcountrypublications(dot)co(dot)uk |
Cc: | andrewy(at)rnd(dot)celcom(dot)com(dot)my, pgsql-cygwin(at)postgresql(dot)org |
Subject: | Re: RE: RE: Win95 PostGreSQL |
Date: | 2001-06-20 08:55:26 |
Message-ID: | 1C1D4B81.310275D7.00013D13@netscape.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
"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/
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - WCP | 2001-06-20 09:06:51 | RE: RE: RE: Win95 PostGreSQL |
Previous Message | Henshall, Stuart - WCP | 2001-06-20 08:35:01 | RE: RE: Win95 PostGreSQL |