Problem creating database using windows2k + cygwin + cygipc

Started by Tony Nicolover 24 years ago2 messagesbugs
Jump to latest
#1Tony Nicol
tnicol@bigpond.net.au

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tony Nicol (#1)
Re: Problem creating database using windows2k + cygwin + cygipc

"Tony Nicol" <tnicol@bigpond.net.au> writes:

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

No, all those debug messages are perfectly normal.

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'?

Not sure about this; does cygwin support unix-style sockets at all?
Try starting the postmaster with -i and then connecting via TCP/IP
(eg, "psql -h localhost").

regards, tom lane