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 1sF5t2-006tTE-Vm for pgadmin-hackers@arkaria.postgresql.org; Thu, 06 Jun 2024 05:42:10 +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 1sF5s4-00FOpt-Uw for pgadmin-hackers@arkaria.postgresql.org; Thu, 06 Jun 2024 05:41:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sF5s4-00FOpk-LH for pgadmin-hackers@lists.postgresql.org; Thu, 06 Jun 2024 05:41:08 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sF5rz-000EwU-QT for pgadmin-hackers@lists.postgresql.org; Thu, 06 Jun 2024 05:41:07 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-5ba090b0336so243584eaf.1 for ; Wed, 05 Jun 2024 22:41:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1717652461; x=1718257261; 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=s8xCm/Q/TMS6tqhqn8+Gk01VRytKiZmNiuWrxsBMZTI=; b=KDW50y8EGXxMiCN9IIS8aXymLfrn+EWFRKv1/9pNmUhKvkwJL3QLWUOLQ3ruzN3fFw y2wKB90EItItPpodE6uLR4DKB7mOLFf+qOpliNvRRJsn53Z0ovOlpAhdq1eXZYx1NT5o bbI8eBl+Gsl4EJeZJ1PZckmzceH9FNJpz1zaGhVZdynd4kaIFd2VEWR16YZALUrAkdhC LFDYyFBlSXntTZsdbIcoKldjGvcLIHskT8BwcM1HowEPiaVTkMt/EZ/hLQtKwb3pg9Dc PSeUyOXzUFJ7hoK6TMelPiQbLVy8eWnvikF+n3wHHtpFnz/lvWZh00ULYxtuPTyqQH5D Op7w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717652461; x=1718257261; 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=s8xCm/Q/TMS6tqhqn8+Gk01VRytKiZmNiuWrxsBMZTI=; b=v3o7CwitXA3QGkcIJ1B4NP5k9kaShdKqO1Lc48NV8NWAWTvE15p6r7d8QvX5xVcVcK 0L0P7RNSe6Fz9N6zjaYB3zSgIzCy+VTqQujnK3KBIgBD6BYODP89R2nTEedmc0PHPMRq CeAcTJown5WCzArGZ05zknnG7yjOSkPiPmc4cJQDQRm12AF5RsmNwzmWV8lwbjUy5MjC 4OPryUWcXnWb4lhU7+YgdDBJv6arEgGO/Q1mxqn2PfbBFmW1gFqxT2w/gATo1plCbZeV Y2JyclVN9Dun0XD9b5e0plsSJ/VfzHlbXYbNrxaU+MWu+Cl1Izm1zItXlIVFOcvZt70S CVIA== X-Forwarded-Encrypted: i=1; AJvYcCWoZ0DB+Vi8SX0I1vr2tR5CL0HAvBrBfebzSMF62m8M4PsE4k57pev9J0LhmBVvyk0cVoQv1L83cIL/Vb02h498ZVjQn1rAAWSGziZBy0RTAmVyI4U= X-Gm-Message-State: AOJu0YwmX5QuJhU0RLzbWTXPO5ElIxPgsIGCU9WSt6GJRtyiX4Upbb4L zrFAbRXaVGxZ7sBXaXoXTv1gYdCQHK4kCcDHp7sU0qnZBivO0TSzn1UA8nq3g+VA6t+1WFdNb03 Buo8rEg5Q3xA17S46iYhxQ4CEo9OLLuB7W8KPHKgMvzEO/5s= X-Google-Smtp-Source: AGHT+IFX1uDeCmWsgLPXqHiqmCDNUBij6pNdD5LkG0N4WoqFncyZmwawowjrWRuHt840CRQYHNuoVCTzDJ3JJNd8JB8= X-Received: by 2002:a05:6820:50f:b0:5b9:e77d:e66e with SMTP id 006d021491bc7-5ba7914cf9fmr4860115eaf.9.1717652461461; Wed, 05 Jun 2024 22:41:01 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Thu, 6 Jun 2024 11:10:25 +0530 Message-ID: Subject: Re: suspected behavior with upgrade scenario : pagadmin 8.8 To: Anil Sahoo Cc: Usman Khan , pgadmin-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000d03ca0061a3220a0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d03ca0061a3220a0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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, i= t > auto-detects the postgres servers installed in your system. > > So that duplicate server you are saying is auto detected and the other on= e > 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 sho= w > 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 wro= te: > >> 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 wen= t >> fine. >> 3) When I collapsed the server group, it showed another server added wit= h >> the name 'Postgresql 16' and it is an exact duplicate of the server alre= ady >> 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 >> >> >> --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --000000000000d03ca0061a3220a0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

We could think of avoiding duplicates if a server is a= lready added on the basis of server properties.=C2=A0

On Thu, Jun 6, 2= 024 at 11:00=E2=80=AFAM Anil Sahoo <anil.sahoo@enterprisedb.com> wrote:
Hi Usman,
Once yo= u install PostgreSQL 16 in your system and on opening pgAdmin 4, it auto-de= tects the postgres servers installed in your system.=C2=A0

So that duplicate server you are saying is auto detected and the other o= ne you added manually.=C2=A0

To confirm this you c= an check by going through the steps, Select PostgreSQL 16>Properties tab= >Comments Field, It must be showing `Auto-detected PostgreSQL 16 install= ation with the data directory at <your data directory of PGv16>`. And= the server you added manually does not show any such comments of auto-dete= ction.

If you still have any doubts please let me know.

Regar= ds
Anil

Anil Sahoo

<= span style=3D"font-size:13.3333px;white-space:pre-wrap">Software Engineer

www.enterprisedb.com

Power 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 Usm= an Khan <umk555@gm= ail.com> wrote:
Hi Hackers,

I am verifying build on wi= ndows 11 and during upgrade I faced the following=C2=A0
1) I inst= alled pgadmin 8.7 and added postgresql16 to it.=C2=A0
2) I downlo= aded pgadmin 8.8 and performed an upgrade on 8.7. Upgrade went fine.
<= div>3) When I collapsed the server group, it showed another server added wi= th the name 'Postgresql 16' and it is an exact duplicate of the ser= ver already added to pgadmin.
In my opinion, this behaviour shoul= d be investigated and corrected. The detail of the platform is as=C2=A0foll= ows
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