From: | "Raul Secan" <magnum(at)go(dot)ro> |
---|---|
To: | <raul(at)zerosoft(dot)ro>, <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | psql connection error |
Date: | 2003-12-20 11:49:30 |
Message-ID: | 000b01c3c6ef$55be63d0$75cfe7c1@magnum |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Raul Secan | 2003-12-20 12:01:10 | psql connection error |
Previous Message | shiva | 2003-12-20 06:59:03 | Procedure Lang |