Please Help me with connecting my PostgreSQL

From: Lasntonpeng <lanstonpeng(at)gmail(dot)com>
To: psycopg-owner(at)postgresql(dot)org, psycopg(at)postgresql(dot)org
Subject: Please Help me with connecting my PostgreSQL
Date: 2011-03-31 12:54:34
Message-ID: AANLkTim9t0VkzQhxo0rPqYsG+V+vawqp3jYf+LUQgdU-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

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"?

1.my postgreSQL is running
2.my listeningport is 5432 for sure
3.
root(at)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*

Responses

Browse psycopg by date

  From Date Subject
Next Message Karsten Hilbert 2011-03-31 13:20:27 Re: Please Help me with connecting my PostgreSQL
Previous Message Daniele Varrazzo 2011-03-30 14:09:17 Re: missing psycopg2 database