Skip site navigation (1) Skip section navigation (2)

Re: RE: RE: Win95 PostGreSQL

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 (view raw or flat)
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/

In response to

pgsql-cygwin by date

Next:From: Henshall, Stuart - WCPDate: 2001-06-20 09:06:51
Subject: RE: RE: RE: Win95 PostGreSQL
Previous:From: Henshall, Stuart - WCPDate: 2001-06-20 08:35:01
Subject: RE: RE: Win95 PostGreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group