Re: Unable to connect remotely to postgres db server

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Unable to connect remotely to postgres db server
Date: 2014-09-20 02:59:24
Message-ID: 1411181964522-5819753.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message JORGE MALDONADO 2014-09-20 17:51:42 Advice on index and constraint definition
Previous Message Kevin Struckhoff 2014-09-20 00:13:22 Unable to connect remotely to postgres db server