Postgres Pro
Downloads
Home   >   mailing lists

Thread: connect() failed: No such file or directory

connect() failed: No such file or directory

From
Christian Thrum
Date:
hi all,

my system is:

windows nt
cygipc-1.09-2
cygwin-1.1.7-1
and the binary version of postgresql 7.0 for nt


when i try to start postmaster i get the following output:

$ ./postmaster -d 5
FindExec: found "/usr/pgsql/bin/./postgres" using argv[0]
binding ShmemCreate(key=52e2c1, size=1115136)
DEBUG:  Data Base System is starting up at Sat Mar  3 20:23:08 2001
DEBUG:  Data Base System was shut down at Sat Mar  3 20:17:00 2001
DEBUG:  Data Base System is in production state at Sat Mar  3 20:23:08 2001
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/pgsql/bin/./postmaster: reaping dead processes...

this looks like there is something going wrong....!? but the postmaster
process is running!
(if i do netstat -a the port 5432 is in use)

next i try to create a database and i get the following error:

$ ./createdb testdb
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

has this error anything to do with the (possible) error when starting
postmaster?
if not, what is the reason for the 'connect failed' ???
if yes... how can i fix it?



thanks for help,
christian thrum


ps: if i try to stop the postmaster, i get:

pmdie 2
Fast Shutdown request at Sat Mar  3 20:35:05 2001
DEBUG:  Data Base System shutting down at Sat Mar  3 20:35:05 2001
DEBUG:  Data Base System shut down at Sat Mar  3 20:35:05 2001
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/pgsql/bin/./postmaster: reaping dead processes...
proc_exit(0)
shmem_exit(0)
NOTICE:  IpcMemoryDetach: shmdt(0x???????): Invalid argument
NOTICE:  IpcMemoryDetach: shmdt(0x???????): Invalid argument
NOTICE:  IpcMemoryDetach: shmdt(0x???????): Invalid argument
exit(0)

again, is this normal or has anything to do with my problem ???

Re: connect() failed: No such file or directory

From
Peter Eisentraut
Date:
Christian Thrum writes:

> $ ./createdb testdb
> 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

Quoth the FAQ_NT:

: NOTE:
: By default, PostgreSQL clients like psql communicate using unix domain
: sockets, which don't work on NT.  Start the postmaster with -i, and
: when connecting to the database from a client, set the PGHOST
: environment variable to 'localhost' or supply the hostname on the
: command line.

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

Re: connect() failed: No such file or directory

From
Jason Tishler
Date:
Christian,

On Sun, Mar 04, 2001 at 12:17:06AM +0100, Peter Eisentraut wrote:
> Christian Thrum writes:
>
> > $ ./createdb testdb
> > 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
>
> Quoth the FAQ_NT:
>
> : NOTE:
> : By default, PostgreSQL clients like psql communicate using unix domain
> : sockets, which don't work on NT.  Start the postmaster with -i, and
> : when connecting to the database from a client, set the PGHOST
> : environment variable to 'localhost' or supply the hostname on the
> : command line.

The above is true for 7.0 but not for 7.1beta5.  For reasons like the
above and others, I would suggest using 7.1beta5 or CVS.

Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com