Thread: database creation failed

database creation failed

From
"Jeff Lu"
Date:
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@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


RE: database creation failed

From
Michael Davis
Date:
Did you run initdb?  If so, You may need to delete your data directory (or
create a new one), re-create it, run initdb, re-import your data.  What did
you do to overcome the last issue?  I would like to get that documented on
my web site.

Thanks, Michael

-----Original Message-----
From:    Jeff Lu [SMTP:jklcom@mindspring.com]
Sent:    Thursday, February 08, 2001 11:27 AM
To:    pgsql-ports@postgresql.org
Subject:    [PORTS] database creation failed


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


Re: database creation failed

From
Peter Eisentraut
Date:
Jeff Lu writes:

> 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

Try 'createdb -h localhost test'.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/