Re: Please Help me with connecting my PostgreSQL

On Thursday, March 31, 2011 5:54:34 am Lasntonpeng wrote:
> It's the first time that I can't find the answer about some tech problems
>
> Here's my problems:
> >>conn=psycopg2.connect(database="mydb", user="postgres",
>
> password="123",port=5433)
>
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
> psycopg2.OperationalError: could not connect to server: No such file or
> directory
>  Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Two problems. The first is the one Karsten already mentioned about the difference
on ports. Second you have not specified a host so Psycopg is trying the local
socket. If you are trying to connect from a machine other than the other one
with the Postgres server it is not going to find the socket. Also the socket
connection may have a  restriction in pg_hba.conf that would prevent a
connection.

>
>
>
> 1.my postgreSQL is running
> 2.my listeningport is 5432 for sure
> 3.
> root@lanston-laptop:~# psql -l
> Password:
>                                    List of databases
>      Name      |  Owner   | Encoding | Collation  |   Ctype    |   Access
> privileges
> ---------------+----------+----------+------------+------------+-----------
> ------------ checkdatabase | postgres | UTF8     | en_US.utf8 | en_US.utf8
> |
>  mydb          | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
>  postgres      | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
>  template0     | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
> =c/postgres +
>
> postgres=CTc/postgres
>  template1     | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
> =c/postgres +
>
> postgres=CTc/postgres
> (5 rows)
>
>
> *This is the problem that so many people asked,but there's no answers.*
> *Thanks a lot*

--
Adrian Klaver
adrian.klaver@gmail.com