Thread: Unable to connect remotely to postgres server

Unable to connect remotely to postgres server

From
Kevin Struckhoff
Date:

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 how do i configure pg_hba.conf for my pc to connect?

 

Thanks.

 

Kevin

 

 

Re: Unable to connect remotely to postgres server

From
amul sul
Date:
 
Try to add ADDRESS column in pg_hba.conf as 192.168.xxx.0/24 or 192.168.0.0/16
 
Regards,
Amul Sul


On Monday, 22 September 2014 3:52 AM, Kevin Struckhoff <kevins@thermal.com> 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 how do i configure pg_hba.conf for my pc to connect?

 
Thanks.
 
Kevin