Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: Connecting to Postgresql without IP address

Re: Connecting to Postgresql without IP address

From
"sivapostgres@yahoo.com"
Date:
Hello,

Using PostgreSQL 11

Currently connecting PostgreSQL database from our Powerbuilder application using the IPAddress as Server Name through ODBC driver.  Would like to know whether we can connect naming the computername instead of IP Address ?  If yes, what info to be entered in pg_hba.config file ?

My connection string is :
"ConnectString='Driver=PostgreSQL Unicode;Database=dbname;Server=192.168.1.21;Port=5432;UID=user;PWD=pass;',DisableBind=1"

Here Server is assigned with IP Address of the computer where PostgreSQL is installed.  
I think of doing it with 
"ConnectString='Driver=PostgreSQL Unicode;Database=dbname;Server=PGServer;Port=5432;UID=user;PWD=pass;',DisableBind=1"

Is it possible ?   

Happiness Always
BKR Sivaprakash

Re: Connecting to Postgresql without IP address

From
Ben Madin
Date:
Your connection string will work as long as there is a DNS entry for PGServer.

Your pg_hba.conf will however need to have an IP address/netmask. So if you are connecting from within your local network, you can put something like:

hostssl     all      all      192.168.0.0/16       md5

Hth?


On Wed, 30 Jun 2021 at 15:54, sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote:
Hello,

Using PostgreSQL 11

Currently connecting PostgreSQL database from our Powerbuilder application using the IPAddress as Server Name through ODBC driver.  Would like to know whether we can connect naming the computername instead of IP Address ?  If yes, what info to be entered in pg_hba.config file ?

My connection string is :
"ConnectString='Driver=PostgreSQL Unicode;Database=dbname;Server=192.168.1.21;Port=5432;UID=user;PWD=pass;',DisableBind=1"

Here Server is assigned with IP Address of the computer where PostgreSQL is installed.  
I think of doing it with 
"ConnectString='Driver=PostgreSQL Unicode;Database=dbname;Server=PGServer;Port=5432;UID=user;PWD=pass;',DisableBind=1"

Is it possible ?   

Happiness Always
BKR Sivaprakash

--
--

Sent from my iPhone.

Re: Connecting to Postgresql without IP address

From
"sivapostgres@yahoo.com"
Date:
Thanks Ben,

It's NOT working.   Already an entry similar to this is there

host all all 192.168.1.0 255.255.255.0 md5

And I added the following entry also in the hba file and restarted PG Server
hostssl all all 192.168.1.0/16 md5

And tried to connect using server computer name instead of IP address.  I get an error, when I try to add and test and ODBC entry

Inline image

Any thing else I need to do ?

Happiness Always
BKR Sivaprakash




On Thursday, 1 July, 2021, 06:15:45 am IST, Ben Madin <ben@ausvet.com.au> wrote:


Your connection string will work as long as there is a DNS entry for PGServer.

Your pg_hba.conf will however need to have an IP address/netmask. So if you are connecting from within your local network, you can put something like:

hostssl     all      all      192.168.0.0/16       md5

Hth?


On Wed, 30 Jun 2021 at 15:54, sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote:
Hello,

Using PostgreSQL 11

Currently connecting PostgreSQL database from our Powerbuilder application using the IPAddress as Server Name through ODBC driver.  Would like to know whether we can connect naming the computername instead of IP Address ?  If yes, what info to be entered in pg_hba.config file ?

My connection string is :
"ConnectString='Driver=PostgreSQL Unicode;Database=dbname;Server=192.168.1.21;Port=5432;UID=user;PWD=pass;',DisableBind=1"

Here Server is assigned with IP Address of the computer where PostgreSQL is installed.  
I think of doing it with 
"ConnectString='Driver=PostgreSQL Unicode;Database=dbname;Server=PGServer;Port=5432;UID=user;PWD=pass;',DisableBind=1"

Is it possible ?   

Happiness Always
BKR Sivaprakash

--
--

Sent from my iPhone.