Re: Mystery "PostgreSQL 11" server keeps reappearing in pgAdmin 4 nomatter how many times I delete it.

On Tue, Apr 21, 2020 at 8:57 AM <tutiluren@tutanota.com> wrote:

Ever since I went through the horrible ordeal of trying to update PostgreSQL on Windows (from 11.5 to 11.7, so not even a major version), pgAdmin 4 has started showing a "PostgreSQL 11" server in the list of servers. I've deleted it a hundred times now, but it just keeps reappearing every time I start pgAdmin 4.

I'm not sure how that would be a horrible ordeal. You just run the installer and it upgrades with a few clicks.

 

What is this? How to *actually* remove it rather than "pretend-removing" it? Why is it there at all? I never added any such server to pgAdmin 4, and why would it keep adding it back?

Don't remove it. Rename it and/or change any settings you require, then delete the one you manually added.

 

If trying to connect to it, it asks for a password. I enter none and connect. It seems to be an identical copy of the actual server. In the comments, it says:

Auto-detected PostgreSQL 11 installation with the data directory at C:\Users\blablabla...

Okay, so pgAdmin 4 auto-detected what I already have as a named server in the list, and keeps adding it back? I don't understand the point. Especially the part where it keeps reappearing when I delete it.

It doesn't know that the server you added is the same connection; you might intentionally have the same server added twice, but with subtle differences in the settings. It keeps track of the ID of the server from the registry, and if it finds a server listed in the registry doesn't exist, it'll auto-add it (and store the ID so it doesn't duplicate it itself).

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company