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