Review the postgresql.conf and chek the "listen_adress" parameter. listen_adress="localhost" Change localhost by * Example: listen_adress="*" Este mensaje ha sido enviado gracias al servicio BlackBerry de Movilnet -----Original Message----- From: Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> Sender: pgsql-admin-owner@postgresql.orgDate: Wed, 10 Jul 2013 19:06:23 To: Struckhoff, Kevin<kstruckhoff@xxxxxxxx> Cc: Kevin Grittner<kgrittn@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxx<pgsql-admin@xxxxxxxxxxxxxx> Subject: Re: Connecting to a remote db server Struckhoff, Kevin wrote: > I'm trying to use the psql tool: > > /home/postgres->psql test > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > > the answer of course is No.. Oh, well, you need to specify the hostname or address of the remote server: psql -h db01 test Otherwise, it's just trying to connect to localhost, as you've seen. You might need to adjust pg_hba.conf on the db01 server to allow connections from your app01 client host. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
