Problem creating database using windows2k + cygwin + cygipc

From: "Tony Nicol" <tnicol(at)bigpond(dot)net(dot)au>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem creating database using windows2k + cygwin + cygipc
Date: 2001-12-18 11:20:28
Message-ID: 000801c187b6$0127fcc0$28578990@spearsystem2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi there,

I am running windows 2000 (service pack 2) with latest version of cygwin and cygipc installed.

when running initdb I get the following (this is for installation of brand new database with postgreSQL not installed prior to this install):

PGDATA=/PGDATA
$ initdb
This database system will be initialized with username "Tony".
This user will own all the data files and must also own the server process.

Fixing permissions on existing directory /PGDATA
Creating directory /PGDATA/base
Creating directory /PGDATA/global
Creating directory /PGDATA/pg_xlog
Creating template1 database in /PGDATA/base/1
DEBUG: database system was shut down at 2001-12-18 22:05:48
DEBUG: CheckPoint record at (0, 8)
DEBUG: Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 16384
DEBUG: database system is in production state
Creating global relations in /PGDATA/global
DEBUG: database system was shut down at 2001-12-18 22:05:55
DEBUG: CheckPoint record at (0, 112)
DEBUG: Redo record at (0, 112); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 17199
DEBUG: database system is in production state
Initializing pg_shadow.
Enabling unlimited row width for system tables.
Creating system views.
Loading pg_description.
Setting lastsysoid.
Vacuuming database.
Copying template1 to template0.

Success. You can now start the database server using:

/bin/postmaster -D /PGDATA
or
/bin/pg_ctl -D /PGDATA -l logfile start

i.e. the DEBUG's are indicative of something not right...

when I try using pg_ctl start I get...
$ pg_ctl start
postmaster successfully started
DEBUG: database system was shut down at 2001-12-18 22:06:51
DEBUG: CheckPoint record at (0, 1563240)
DEBUG: Redo record at (0, 1563240); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system is in production state

when I try using psql I get...
$ psql
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running locally
and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?

HELP!!!!!

Many thanks for any help you can give.

Tony Nicol

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-12-18 14:58:53 Re: stuck spinlock. Aborting. What does this mean?
Previous Message pgsql-bugs 2001-12-18 10:29:42 Bug #542: 7.1.3 will not compile/install on SCO Open Server 5.0.4/5.0.5