Skip site navigation (1) Skip section navigation (2)

psql connection error

From: "Raul Secan" <magnum(at)go(dot)ro>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: psql connection error
Date: 2003-12-20 12:01:10
Message-ID: 003e01c3c6f0$f65ee250$75cfe7c1@magnum (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hello, I succesfuly installed PostgreSQL 7.3.3 on Cygwin 1.3.22.
I am running WinXP Professional, and the PostgreSQL and ipc-daemon, are installed as Windows services.

Well I can stop them, and start them and everything seems to look normal.

The point is that I can't connect with psql command to the server, but I can connect with phpPgAdmin, and make all operations available there.

I realy need to use psql command, but when I try to connect I receive this:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$ psql -d template1 -U postgre

psql: could not connect to server: Bad file descriptor
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"? 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

My pgsql data directory is: /home/postgre/data/

I also verify the pg_hba.conf file an have there:
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                             trust
host    all         all         127.0.0.1         255.255.255.255   trust

So it looks ok, and I even uncomment the line port = 5432 from postgresql.conf.

I just don't know what is happening.

I even try this:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$ pg_ctl status
pg_ctl: no database directory or environment variable $PGDATA is specified
Try 'pg_ctl --help' for more information.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Can someone help me? Thanks.

Responses

pgsql-cygwin by date

Next:From: Fábio M. PóvoaDate: 2003-12-22 10:14:39
Subject: unsubscribe me
Previous:From: Raul SecanDate: 2003-12-20 11:49:30
Subject: psql connection error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group