From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Paul Strauss <pstrauss@carallel.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Database not appearing in PGadmin 4
Date: Thu, 18 Apr 2024 07:21:26 +0200
Message-ID: <03e89a24b1969225baf672b2d2e91e8199c4c7b9.camel@cybertec.at> (raw)
In-Reply-To: <CAFjfTx-xQt3vfugLQ8exHhG9Mcv37DAV9+XUXCz6Li1UcMvS+g@mail.gmail.com>
References: <CAFjfTx-xQt3vfugLQ8exHhG9Mcv37DAV9+XUXCz6Li1UcMvS+g@mail.gmail.com>
On Wed, 2024-04-17 at 21:29 -0500, Paul Strauss wrote:
> We recently removed an empty database in Postgres and renamed another database
> to have that same name. However the newly renamed database does not appear in
> PGAdmin even though all of the proper permissions have been granted to the user.
>
> When using the PG shell within PGAdmin the user is able to see the database and query it.
>
> Can you think of a reason this would be happening? The same issue is happening
> to two users with PGAdmin and the database is accessible from other clients.
There are two possibilities:
1. you didn't refresh pgAdmin's display
2. pgAdmin is connected to a different cluster
> The information contained in this communication is confidential [...]
I see. I won't tell anybody.
Yours,
Laurenz Albe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, pstrauss@carallel.com, pgsql-admin@lists.postgresql.org
Subject: Re: Database not appearing in PGadmin 4
In-Reply-To: <03e89a24b1969225baf672b2d2e91e8199c4c7b9.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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