Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sF60O-006ukk-6i for pgadmin-hackers@arkaria.postgresql.org; Thu, 06 Jun 2024 05:49:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sF60O-00FRzx-6Q for pgadmin-hackers@arkaria.postgresql.org; Thu, 06 Jun 2024 05:49:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sF60N-00FRxg-N6 for pgadmin-hackers@lists.postgresql.org; Thu, 06 Jun 2024 05:49:43 +0000 Received: from mail-qk1-x732.google.com ([2607:f8b0:4864:20::732]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sF60K-003gw5-QU for pgadmin-hackers@lists.postgresql.org; Thu, 06 Jun 2024 05:49:42 +0000 Received: by mail-qk1-x732.google.com with SMTP id af79cd13be357-7952b60b4d7so33531985a.1 for ; Wed, 05 Jun 2024 22:49:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717652980; x=1718257780; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=JQa162Ca+5HxPVqb1dMCEj6YtJekngXpZaKwwQ5SS64=; b=MhiJVzIK8GaeJc38rvaGJvQ0Svlb8s2V1nIYN7jsH07fp6V/xirfJhnBAKsxUz5P+o XJ7RpMJVtU8BS+6Wz/pdU3tmfzxju09Ww1rI8yY3MRUU5B6dcHtmO0KQ+ESOy4SEaIuF cUck8MJvTE6XihP83aleH6BJf5JJ6gkbUScUpB8ZE2h6SxpLhWbfrArjZOrEZcSSdXc2 4jWz66yu9tqwIBxeVP2N1qNyfY9Vt9tjwtLSL3rAmk/LxGM7wG1Iz2AQKSzFNuXuJ/Gm HZ9LRVbQzxOpVW6xv4FXjw8n6BQi9IQ+T+csbL6DlDeJQoQn6Cx7k9pM+CLF8dDiP3/c /vxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717652980; x=1718257780; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=JQa162Ca+5HxPVqb1dMCEj6YtJekngXpZaKwwQ5SS64=; b=tJY5uGseiF9gJvGAASqTQrJ68HJDybSY8uud4mIJ7t3O4CIedrAXeVCHdHf8vM6ILp Tfnc39ruYuwYPNI4By7eZiyfNl+KElNY5GhrPVB8C5sWLEou2AMP8W8NPnPNrRrez+U9 CImIeytoF72+3QQiwwj9Oecyv1y1m4Zt6LY6s3oSnEsTlelEbWSFRLBRtxjjKKpNIHhD ZJV31Gk9Anitwt0LVo+9b1pkmYqqmhFphJWEJW4fU8V+RNAw499H6yyKdqVzziaDoN0B zDi4R3Nm9lsM4Q2J9pEDwG4ri/u49c5q3HgKbzggp4lVwviqIQ+1ko+58mGxJpB8qld9 2i+g== X-Forwarded-Encrypted: i=1; AJvYcCVd7+vaEaVze+/KW330iDazeuUDjBzoEAjJltrj81CpwKqAsFS+5nArbpjfvAMmu+J4f9dHMfrSF8qyaOeNk3kNAytsskVfIafdN402esklv3fHTms= X-Gm-Message-State: AOJu0YwK9sGaK5EDuPEzs8dspTC3LzCiKcULe9kt1IyYk556jDjkdufO 1mmEGGXjXmXqyY3avw2LcqWyFFfgP7Je4yW7IO3yckhbQ0Ne77rXBE451NT1xLosUXCQsS31Lp4 Z/oBrjowNSRdAK9665r0Rt3yDPQof05Bpl/M= X-Google-Smtp-Source: AGHT+IEe+oDkUYnb8SjoQsdOP/BD6IxAtG3oNcwYUJrH9JaxReips6eUaw4oulQ1A7MNHE4getDAOqjRboQjCq2ciBs= X-Received: by 2002:a05:620a:b8a:b0:794:a84f:9ef2 with SMTP id af79cd13be357-79523d35ce9mr435480585a.23.1717652979740; Wed, 05 Jun 2024 22:49:39 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Usman Khan Date: Thu, 6 Jun 2024 10:49:28 +0500 Message-ID: Subject: Re: suspected behavior with upgrade scenario : pagadmin 8.8 To: Aditya Toshniwal Cc: Anil Sahoo , pgadmin-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000b47fc2061a323fce" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b47fc2061a323fce Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable +1 On Thu, Jun 6, 2024 at 10:41=E2=80=AFAM 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=E2=80=AFAM Anil Sahoo > 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 > data directory of PGv16>`. And the server you added manually does not sh= ow >> any such comments of auto-detection. >> >> If you still have any doubts please let me know. >> >> Regards >> Anil >> >> >> >> *Anil Sahoo* >> >> Software Engineer >> >> www.enterprisedb.com >> >> Power to Postgres >> >> >> >> >> >> >> >> On Thu, Jun 6, 2024 at 10:40=E2=80=AFAM Usman Khan wr= ote: >> >>> 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 serve= r >>> 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 >>> >>> >>> > > -- > Thanks, > Aditya Toshniwal > pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* > > "Don't Complain about Heat, Plant a TREE" > --000000000000b47fc2061a323fce Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
+1

On Thu, Jun 6, 2024 at 10:41=E2=80=AFAM Aditya Toshn= iwal <aditya.toshni= wal@enterprisedb.com> wrote:
Hi,

We could think of avoiding duplica= tes if a server is already added on the basis of server properties.=C2=A0

On Thu, Jun 6, 2024 at 11:00=E2=80=AFAM Anil Sahoo <anil.sahoo@enterprisedb.co= m> wrote:
Hi Usman,
Once you install PostgreSQL 16 in your syste= m and on opening pgAdmin 4, it auto-detects the postgres servers installed = in your system.=C2=A0

So that duplicate server you are s= aying is auto detected and the other one you added manually.=C2=A0

To confirm this you can check by going through the steps, = Select PostgreSQL 16>Properties tab>Comments Field, It must be showin= g `Auto-detected PostgreSQL 16 installation with the data directory at <= your data directory of PGv16>`. And the server you added manually does n= ot show any such comments of auto-detection.

If you still have any d= oubts please let me know.

Regards
Anil

Anil Sahoo

<= p dir=3D"ltr" style=3D"line-height:1.2;margin-top:0pt;margin-bottom:0pt">Software Engineer

www.enterprisedb.com<= /a>

Po= wer to Postgres

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0



On Thu, Jun 6, 2024 at 10:40=E2=80=AFAM Usman Khan <umk555@gmail.com> wrote:
Hi Hack= ers,

I am verifying build on windows 11 and during upgrade I f= aced the following=C2=A0
1) I installed pgadmin 8.7 and added pos= tgresql16 to it.=C2=A0
2) I downloaded pgadmin 8.8 and performed = an upgrade on 8.7. Upgrade went fine.
3) When I collapsed the ser= ver group, it showed another server added with the name 'Postgresql 16&= #39; 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=C2=A0follows
platform: windows= 11 Home
packages: pgadmin 8.7 and 8.8
The snapshot is = attached for more information.

Regards,
= Usman Muzaffar




--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Sr. Software Architect=C2=A0| enterprisedb.com