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