Thread: RE: RE: RE: Win95 PostGreSQL

RE: RE: RE: Win95 PostGreSQL

From
Andrew
Date:
Errr.....just a problem.....i don't seem to able to find  the ipc-daemon on the installed directory of cygwin.

If I do a initdb -D test ,  it hangs on the last line. I don't know if my installation is a ok entirely.
But I believe it is complete as I use the cygwin setup program.

$ initdb -D test
This database system will be initialized with username "andrew".
This user will own all the data files and must also own the server process.

Fixing permissions on existing directory test
Creating directory test/base
Creating directory test/global
Creating directory test/pg_xlog
Creating template1 database in test/base/1


-----Original Message-----
From:    S. L. [SMTP:s0lao@netscape.net]
Sent:    Wednesday, June 20, 2001 4:55 PM
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

> Hope this helps,
> - Stuart
>
>
> > -----Original Message-----
> > From: Andrew [SMTP:andrewy@rnd.celcom.com.my]
> > Sent: Wednesday, June 20, 2001 7:46 AM
> > To:   'pgsql-cygwin@postgresql.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@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@postgresql.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/