psql is official postgresql client

learn more… | top users | synonyms

1
vote
1answer
369 views

postgres server works on LAN but not WAN (connection refused)

I'm trying to set up a postgres server, but I cannot access it through the Internet. It works fine on my LAN. Server is just a desktop computer using Ubuntu 12.04 desktop. disclaimer: I am not ...
1
vote
1answer
260 views

PSQL error with restarting postgres in SSL

I set up server.crt, root.crt and servery.key in postgresql (using http://howtoforge.com/postgresql-ssl-certificates for instructions), set ssl = on and restarted the service successfully. However, ...
-1
votes
1answer
266 views

Unable to login in phpPgAdmin

I am trying to login to phpPgAdmin from a remote client. I've created the user root, but when I login phpPgAdmin returns an error message saying "Unable to login" When I check the log it says: ...
2
votes
0answers
210 views

Postgres roles best practice implementation

Folks, I could use your help making my Postgres user access control design better and more aligned with best practices. I'm helping roll out a small production Postgres server but I am not a DB ...
0
votes
0answers
246 views

psql on putty shows no output

I am using Windows Vista with Cygwin running on a PUTTY console. When I issue the command "psql -l -U grants -W", there is no output (i.e. no prompt for the password even): But echo works ok.. Fri ...
0
votes
0answers
292 views

Can't connect to PostgreSQL with PHP in Fedora

My PostgreSQL is running properly and I can access it via terminal. phpinfo() gives following information regarding the installation: pdo_pgsql PDO Driver for PostgreSQL enabled PostgreSQL(libpq) ...