Re: Connecting to Postgresql without IP address

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 Serverhostssl all all 192.168.1.0/16 md5 And tried to connect using server computer name instead of IP address

Re: Ubuntu 14.04 (trusty) Postgres 13 deb package

On 6/30/21 5:40 PM, Bhavesh Mistry wrote: Hi Joshua, Thank you for your email.  I understand it is EOL, but I wanted to know a way to build a deb package for myself.  I have succeeded in building PSQL 13 on 14.04, but without some extensions so I am trying it out.  Due to the legacy system, w

Re: Ubuntu 14.04 (trusty) Postgres 13 deb package

Hi Joshua, Thank you for your email. I understand it is EOL, but I wanted to know a way to build a deb package for myself. I have succeeded in building PSQL 13 on 14.04, but without some extensions so I am trying it out. Due to the legacy system, we had to use 14.04. Thanks, Bhavesh On Mon,

Re: Connecting to Postgresql without IP address

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 W

Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1

Hello all, Yesterday, a new release of the RPM definition has been released, in order to integrate many cool updates: https://git.postgresql.org/gitweb/?p=pgrpms.git;a=summary And at 10PM yesterday, we encountered a problem on the postgresql instance upgrades that were performed pointing to the p

DBAs using PostgreSQL sought for paid research study

Hi, Redgate software a leading provider of database development and monitoring tools are carrying out some research to better understand how organisations monitor their PostgreSQL databases. If you're a DBA (or similar) looking after production PostgreSQL databases we

Re: Connecting to Postgresql without IP address

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.conf