Hi there,
I am running windows 2000 (service pack 2) with latest version of cygwin an=
d 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=3D/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