Re: Connecting to a remote db server - Mailing list pgsql-admin

From javmendez1@gmail.com
Subject Re: Connecting to a remote db server
Date
Msg-id 966757031-1373500246-cardhu_decombobulator_blackberry.rim.net-346490267-@b27.c8.bise6.blackberry
Whole thread Raw
In response to Connecting to a remote db server  ("Struckhoff, Kevin" <kstruckhoff@ebay.com>)
List pgsql-admin
Ok, the aplication server and your laptop have the IP adress in the same subnet ?
 
Este mensaje ha sido enviado gracias al servicio BlackBerry de Movilnet

-----Original Message-----
From: "Struckhoff, Kevin" <kstruckhoff@ebay.com>
Date: Wed, 10 Jul 2013 23:45:01 
To: javmendez1@gmail.com<javmendez1@gmail.com>; Alvaro Herrera<alvherre@2ndquadrant.com>;
pgsql-admin-owner@postgresql.org<pgsql-admin-owner@postgresql.org>
Cc: Kevin Grittner<kgrittn@ymail.com>; pgsql-admin@postgresql.org<pgsql-admin@postgresql.org>
Subject: RE: [ADMIN] Connecting to a remote db server

I already did that. In fact, it works fine for pgAdmin III access from my laptop to my db server. 

Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations

kstruckhoff@ebay.com    ebayenterprise.com
o: 818.686.4719  | c: 818.968.0634 | 



The information contained in this electronic mail transmission is intended only for the use of the individual or entity
namedin this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any
disclosure,copying or distribution of the contents of this transmission is strictly prohibited and that you should
deletethe contents of this transmission from your system immediately. Any comments or statements contained in this
transmissiondo not necessarily reflect the views or position of eBay Enterprise or its subsidiaries and/or affiliates.
 

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of javmendez1@gmail.com
Sent: Wednesday, July 10, 2013 4:19 PM
To: Alvaro Herrera; pgsql-admin-owner@postgresql.org; Struckhoff, Kevin
Cc: Kevin Grittner; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting to a remote db server

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@2ndquadrant.com>
Sender: pgsql-admin-owner@postgresql.orgDate: Wed, 10 Jul 2013 19:06:23 
To: Struckhoff, Kevin<kstruckhoff@ebay.com>
Cc: Kevin Grittner<kgrittn@ymail.com>; pgsql-admin@postgresql.org<pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: javmendez1@gmail.com
Date:
Subject: Re: Connecting to a remote db server
Next
From: Kevin Grittner
Date:
Subject: Re: Connecting to a remote db server