From: | "Jeff Lu" <jklcom(at)mindspring(dot)com> |
---|---|
To: | <pgsql-ports(at)postgresql(dot)org> |
Subject: | database creation failed |
Date: | 2001-02-08 18:26:39 |
Message-ID: | NDBBIHPECLIGKCCLMACAGEKICJAA.jklcom@mindspring.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
I'm new to cygwin(1.1.6) & postgreSQL(7.0.3).
when start postmaster:
postmaster -i&
I got:
DEBUG: Data Base System is starting up at Thu Feb 8 10:12:53 2001
DEBUG: Data Base System was interrupted being in production at Wed Feb 7
23:02:36 2001
DEBUG: Data Base System is in production state at Thu Feb 8 10:12:53 2001
psql -h localhost template1
when try to create database
$ createdb test
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
createdb: database creation failed
jeff(at)T3 ~
$ ps -l
PID PPID PGID WINPID TTY UID STIME COMMAND
230 1 230 176 -1 1000 11:04:47
/usr/local/bin/ipc-daemon
206 1 206 206 -1 1000 12:03:08 /usr/bin/bash
216 206 216 170 -1 1000 12:03:22
/usr/local/pgsql/bin/postgres
228 206 228 197 -1 1000 12:04:20
/usr/local/pgsql/bin/psql
166 216 216 166 -1 1000 12:04:20
/usr/local/pgsql/bin/postgres
235 206 235 196 -1 1000 12:04:44 /usr/bin/psCan you
help?
This is what I have in pg_hda.conf
# By default, allow anything over UNIX domain sockets and localhost.
local all trust
host all 127.0.0.1 255.255.255.255 trust
Please help
Thank you
-Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Leonid Furman | 2001-02-08 20:01:27 | |
Previous Message | Fabio Nanni | 2001-02-08 10:55:48 | SELECT with regular pattern '~' delivers wrong output |