Обсуждение: Problem creating database using windows2k + cygwin + cygipc

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

"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