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*
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 |