Thread: suspected behavior with upgrade scenario : pagadmin 8.8
Hi Hackers,
I am verifying build on windows 11 and during upgrade I faced the following
1) I installed pgadmin 8.7 and added postgresql16 to it.
2) I downloaded pgadmin 8.8 and performed an upgrade on 8.7. Upgrade went fine.
3) When I collapsed the server group, it showed another server added with the name 'Postgresql 16' and it is an exact duplicate of the server already added to pgadmin.
In my opinion, this behaviour should be investigated and corrected. The detail of the platform is as follows
platform: windows 11 Home
packages: pgadmin 8.7 and 8.8
The snapshot is attached for more information.
Regards,
Usman Muzaffar
Attachment
Hi Usman,
Once you install PostgreSQL 16 in your system and on opening pgAdmin 4, it auto-detects the postgres servers installed in your system.
Once you install PostgreSQL 16 in your system and on opening pgAdmin 4, it auto-detects the postgres servers installed in your system.
So that duplicate server you are saying is auto detected and the other one you added manually.
To confirm this you can check by going through the steps, Select PostgreSQL 16>Properties tab>Comments Field, It must be showing `Auto-detected PostgreSQL 16 installation with the data directory at <your data directory of PGv16>`. And the server you added manually does not show any such comments of auto-detection.
If you still have any doubts please let me know.
Regards
Anil
If you still have any doubts please let me know.
Regards
Anil
Anil Sahoo Software Engineer Power to Postgres | |
On Thu, Jun 6, 2024 at 10:40 AM Usman Khan <umk555@gmail.com> wrote:
Hi Hackers,I am verifying build on windows 11 and during upgrade I faced the following1) I installed pgadmin 8.7 and added postgresql16 to it.2) I downloaded pgadmin 8.8 and performed an upgrade on 8.7. Upgrade went fine.3) When I collapsed the server group, it showed another server added with the name 'Postgresql 16' and it is an exact duplicate of the server already added to pgadmin.In my opinion, this behaviour should be investigated and corrected. The detail of the platform is as followsplatform: windows 11 Homepackages: pgadmin 8.7 and 8.8The snapshot is attached for more information.Regards,Usman Muzaffar
Hi,
We could think of avoiding duplicates if a server is already added on the basis of server properties.
On Thu, Jun 6, 2024 at 11:00 AM Anil Sahoo <anil.sahoo@enterprisedb.com> wrote:
Hi Usman,
Once you install PostgreSQL 16 in your system and on opening pgAdmin 4, it auto-detects the postgres servers installed in your system.So that duplicate server you are saying is auto detected and the other one you added manually.To confirm this you can check by going through the steps, Select PostgreSQL 16>Properties tab>Comments Field, It must be showing `Auto-detected PostgreSQL 16 installation with the data directory at <your data directory of PGv16>`. And the server you added manually does not show any such comments of auto-detection.
If you still have any doubts please let me know.
Regards
Anil
Anil Sahoo
Software Engineer
Power to Postgres
On Thu, Jun 6, 2024 at 10:40 AM Usman Khan <umk555@gmail.com> wrote:Hi Hackers,I am verifying build on windows 11 and during upgrade I faced the following1) I installed pgadmin 8.7 and added postgresql16 to it.2) I downloaded pgadmin 8.8 and performed an upgrade on 8.7. Upgrade went fine.3) When I collapsed the server group, it showed another server added with the name 'Postgresql 16' and it is an exact duplicate of the server already added to pgadmin.In my opinion, this behaviour should be investigated and corrected. The detail of the platform is as followsplatform: windows 11 Homepackages: pgadmin 8.7 and 8.8The snapshot is attached for more information.Regards,Usman Muzaffar
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
Hi Anil,
Thanks for replying.
Yes, I understand that it's auto-detected. That is why I did not report it for a bug. But circulating it through email, I wanted to open a discussion. Can we somehow avoid it? Otherwise, if there are more than one servers, it would be annoying for the user to have duplicated servers.
On Thu, Jun 6, 2024 at 10:30 AM Anil Sahoo <anil.sahoo@enterprisedb.com> wrote:
Hi Usman,
Once you install PostgreSQL 16 in your system and on opening pgAdmin 4, it auto-detects the postgres servers installed in your system.So that duplicate server you are saying is auto detected and the other one you added manually.To confirm this you can check by going through the steps, Select PostgreSQL 16>Properties tab>Comments Field, It must be showing `Auto-detected PostgreSQL 16 installation with the data directory at <your data directory of PGv16>`. And the server you added manually does not show any such comments of auto-detection.
If you still have any doubts please let me know.
Regards
Anil
Anil Sahoo
Software Engineer
Power to Postgres
On Thu, Jun 6, 2024 at 10:40 AM Usman Khan <umk555@gmail.com> wrote:Hi Hackers,I am verifying build on windows 11 and during upgrade I faced the following1) I installed pgadmin 8.7 and added postgresql16 to it.2) I downloaded pgadmin 8.8 and performed an upgrade on 8.7. Upgrade went fine.3) When I collapsed the server group, it showed another server added with the name 'Postgresql 16' and it is an exact duplicate of the server already added to pgadmin.In my opinion, this behaviour should be investigated and corrected. The detail of the platform is as followsplatform: windows 11 Homepackages: pgadmin 8.7 and 8.8The snapshot is attached for more information.Regards,Usman Muzaffar
+1
On Thu, Jun 6, 2024 at 10:41 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi,We could think of avoiding duplicates if a server is already added on the basis of server properties.On Thu, Jun 6, 2024 at 11:00 AM Anil Sahoo <anil.sahoo@enterprisedb.com> wrote:Hi Usman,
Once you install PostgreSQL 16 in your system and on opening pgAdmin 4, it auto-detects the postgres servers installed in your system.So that duplicate server you are saying is auto detected and the other one you added manually.To confirm this you can check by going through the steps, Select PostgreSQL 16>Properties tab>Comments Field, It must be showing `Auto-detected PostgreSQL 16 installation with the data directory at <your data directory of PGv16>`. And the server you added manually does not show any such comments of auto-detection.
If you still have any doubts please let me know.
Regards
Anil
Anil Sahoo
Software Engineer
Power to Postgres
On Thu, Jun 6, 2024 at 10:40 AM Usman Khan <umk555@gmail.com> wrote:Hi Hackers,I am verifying build on windows 11 and during upgrade I faced the following1) I installed pgadmin 8.7 and added postgresql16 to it.2) I downloaded pgadmin 8.8 and performed an upgrade on 8.7. Upgrade went fine.3) When I collapsed the server group, it showed another server added with the name 'Postgresql 16' and it is an exact duplicate of the server already added to pgadmin.In my opinion, this behaviour should be investigated and corrected. The detail of the platform is as followsplatform: windows 11 Homepackages: pgadmin 8.7 and 8.8The snapshot is attached for more information.Regards,Usman Muzaffar--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"