PgAdmin cannot locate my server

From: "Wetmore, Matthew (CTR)" <Matthew(dot)Wetmore(at)express-scripts(dot)com>
To: John Scalia <jayknowsunix(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: PgAdmin cannot locate my server
Date: 2023-04-19 22:04:20
Message-ID: d2adf980696a4b779d4ee39f2158d87f@express-scripts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm assuming this is windows.
I ran into this when PGAdmin is fine with qualified DNS hostname, but the pg_pass file couldn't resolve and needed dotted quad.

The corporate-world structure of windows networking and permissions is a mystery to me...

Just use the dotted quad and move along! lol

From cmd:

nslookup < ple.mydomain.com >

pg_pass.conf
<IP.IP.IP.IP>:<port>:<db>:<User>:<PASSWORD>

-----Original Message-----
From: John Scalia <jayknowsunix(at)gmail(dot)com>
Sent: Monday, April 17, 2023 12:45 PM
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: [EXTERNAL] PgAdmin cannot locate my server

I’ve got something really weird going on. My laptop can easily find my PLE production (production like environment) using a normal nslookup, but PgAdmin emits an error saying could not translate host name “ple.mydomain.com” host to address: Unknown host

So where is PgAdmin looking regarding DNS entries? I would think that if the laptop can find it, that any app running on it should be able to do so.

Jay

Sent from my iPad6

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2023-04-20 00:37:08 Re: pg_cancel_backend and pg_terminate_backend
Previous Message Holger Jakobs 2023-04-19 20:48:18 Re: pg_cancel_backend and pg_terminate_backend