Re: Unable to connect remotely to postgres db server - Mailing list pgsql-novice

From David G Johnston
Subject Re: Unable to connect remotely to postgres db server
Date
Msg-id 1411181964522-5819753.post@n5.nabble.com
Whole thread Raw
In response to Unable to connect remotely to postgres db server  (Kevin Struckhoff <kevins@thermal.com>)
List pgsql-novice
Kevin Struckhoff wrote
> Hello,
>
> I'm having trouble connecting to my postgres db server from my pgAdmin
> desktop app which has a current dhcp IP number of 192.168.xxx.148. It was
> at
> 192.168.xxx.107 earlier today before I rebooted my pc.
>
> I figured out to handle my server ip number which has segment 4 > 128 by
> using 'samehost' as the address entry.

So I'm not sure what you mean by this...


> So how do i configure pg_hba.conf for my pc to connect?

So, how do you have it configured currently and what do you want to have be
allowed?

The documentation is pretty good at telling you how to accomplish something
- you should focus on communicating your goal.

http://www.postgresql.org/docs/9.3/interactive/auth-pg-hba-conf.html

host    all        all             192.168.xxx.148/32        md5

The above works - at least until you next get a new ip addressed assigned by
your DHCP server...

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Unable-to-connect-remotely-to-postgres-db-server-tp5819751p5819753.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


pgsql-novice by date:

Previous
From: Kevin Struckhoff
Date:
Subject: Unable to connect remotely to postgres db server
Next
From: JORGE MALDONADO
Date:
Subject: Advice on index and constraint definition