pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPgAdmin cannot locate my server
4+ messages / 3 participants
[nested] [flat]
* PgAdmin cannot locate my server
@ 2023-04-17 17:44 John Scalia <jayknowsunix@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: John Scalia @ 2023-04-17 17:44 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PgAdmin cannot locate my server
@ 2023-04-17 18:30 Erik Wienhold <ewie@ewie.name>
parent: John Scalia <jayknowsunix@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Erik Wienhold @ 2023-04-17 18:30 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
> On 17/04/2023 19:44 CEST John Scalia <jayknowsunix@gmail.com> wrote:
>
> 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 can't find message "Unknown host" in the pgAdmin source. I'd have to check
but I assume pgAdmin delegates all connection management to psycopg.
> I would think that if the laptop can find it, that any app running on it
> should be able to do so.
How do you run pgAdmin? From the top of my head there's the desktop version,
server version, and Docker container version. In case of the server version
it's plausible that the server uses different DNS settings than your laptop.
Docker containers should inherit the DNS settings of the host but that can be
changed as well.
--
Erik
^ permalink raw reply [nested|flat] 4+ messages in thread
* PgAdmin cannot locate my server
@ 2023-04-19 22:04 Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
parent: John Scalia <jayknowsunix@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Wetmore, Matthew (CTR) @ 2023-04-19 22:04 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@gmail.com>
Sent: Monday, April 17, 2023 12:45 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PgAdmin cannot locate my server
@ 2023-04-20 01:01 John Scalia <jayknowsunix@gmail.com>
parent: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
0 siblings, 0 replies; 4+ messages in thread
From: John Scalia @ 2023-04-20 01:01 UTC (permalink / raw)
To: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
You are correct this problem was from windows and PgAdmin 4v6. At least that’s what my company calls it. The database was an AWS RDS version 12.4.
The eventual fix was even stranger. As an experiment I ran nslookup against the db. Then I reconfigured PgAdmin to connect using the db’s IP address. That all went quite well and I connected with the db. For grins, I reconfigured PgAdmin back to the db’s FQDN, and had it try a reconnection. Strangely enough it did connect and there were no issues., but the only change here was the fact that I first connected using the IP adress.
Sent from my iPad
> On Apr 19, 2023, at 6:04 PM, Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com> wrote:
>
> 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@gmail.com>
> Sent: Monday, April 17, 2023 12:45 PM
> To: Pgsql-admin <pgsql-admin@lists.postgresql.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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-04-20 01:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-04-17 17:44 PgAdmin cannot locate my server John Scalia <jayknowsunix@gmail.com>
2023-04-17 18:30 ` Erik Wienhold <ewie@ewie.name>
2023-04-19 22:04 ` Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
2023-04-20 01:01 ` John Scalia <jayknowsunix@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox