Thread: What is the best way to upgrade pgAdmin on Windows?

What is the best way to upgrade pgAdmin on Windows?

From
毛毛
Date:
Hey there,

I just found out my pgAdmin is version 7.6, while the current version is 8.6. Looks like it's time for an upgrade!

The notification I got had a link to the EDB site with a bunch of PostgreSQL installers listed. Thing is, I don't want to mess up my database. So I figured it'd be smart to learn some best practices for upgrading before I dive in.

Any tips or advice on how to do this safely? Thanks in advance!

Re: What is the best way to upgrade pgAdmin on Windows?

From
Ron Johnson
Date:
On Thu, Aug 15, 2024 at 2:35 AM 毛毛 <krave@163.com> wrote:
Hey there,

I just found out my pgAdmin is version 7.6, while the current version is 8.6. Looks like it's time for an upgrade!


The latest is 8.10.
 
The notification I got had a link to the EDB site with a bunch of PostgreSQL installers listed. Thing is, I don't want to mess up my database.

What does PgAdmin have to do with your database?

(Unless EDB only bundles everything together, in which case you should ask EDB.)
 
So I figured it'd be smart to learn some best practices for upgrading before I dive in.

Any tips or advice on how to do this safely? Thanks in advance!

I'd install 8.10 from https://www.postgresql.org/ftp/pgadmin/pgadmin4/v8.10/windows/, and expect it to overwrite the old version, just like every other Windows and Linux installer does.

--
Death to America, and butter sauce.
Iraq lobster!

Re: What is the best way to upgrade pgAdmin on Windows?

From
Adrian Klaver
Date:
On 8/14/24 23:34, 毛毛 wrote:
> Hey there,
> 
> I just found out my pgAdmin is version 7.6, while the current version is 
> 8.6. Looks like it's time for an upgrade!

Per

https://www.pgadmin.org/download/pgadmin-4-windows/

The current version is 8.10.

> 
> The notification I got had a link to the EDB site with a bunch of 
> PostgreSQL installers listed. Thing is, I don't want to mess up my 
> database. So I figured it'd be smart to learn some best practices for 
> upgrading before I dive in.

pgAdmin4 != Postgres, it is just a GUI client for Postgres.

How did you originally install pgAdmin4?

> 
> Any tips or advice on how to do this safely? Thanks in advance!

-- 
Adrian Klaver
adrian.klaver@aklaver.com




Re:Re: What is the best way to upgrade pgAdmin on Windows?

From
毛毛
Date:


Hi Ron,
 
The notification I got had a link to the EDB site with a bunch of PostgreSQL installers listed. Thing is, I don't want to mess up my database.

What does PgAdmin have to do with your database?
 
I didn't know there was a standalone installer for pgAdmin.

This link brought me to this page: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
I could not find a standalone installer for pgAdmin so I thought I can only upgrade via one of the all-in-one installer.


Hi Adrian,

How did you originally install pgAdmin4?
I started by clicking Download the installer on this page: PostgreSQL: Windows installers 
I ran the installer downloaded and checked the box for pgAdmin during the installation.

Hi Anthony,


I do this often and have never had an issue. It avoids getting two versions of pgAdmin on your Windows machine.

This is exactly what I did. I carried out the installation exactly as described in your book.
What should I do after the uninstallation? Should I download and run installer available on: Download (pgadmin.org)


Thank you!

At 2024-08-16 04:38:26, "Anthony DeBarros" <anthonymdebarros@gmail.com> wrote:


Howdy,


On Thu, Aug 15, 2024 at 2:35 AM 毛毛 <krave@163.com> wrote:
Hey there,

I just found out my pgAdmin is version 7.6, while the current version is 8.6. Looks like it's time for an upgrade!

The notification I got had a link to the EDB site with a bunch of PostgreSQL installers listed. Thing is, I don't want to mess up my database. So I figured it'd be smart to learn some best practices for upgrading before I dive in.

Any tips or advice on how to do this safely? Thanks in advance!


I do this often and have never had an issue. It avoids getting two versions of pgAdmin on your Windows machine.

 

Re: What is the best way to upgrade pgAdmin on Windows?

From
Adrian Klaver
Date:
On 8/15/24 22:02, 毛毛 wrote:
> 
> Hi Ron,

> Hi Adrian,
> 
>     How did you originally install pgAdmin4?
> 
> I started by clicking Download the installer 
> <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads> on this page: PostgreSQL: Windows installers
<https://www.postgresql.org/download/windows/>
> I ran the installer downloaded and checked the box for pgAdmin during 
> the installation.

1) Do you want to have the Postgres server running on your Windows 
machine or do you want to just have pgAdmin4 installed?

2) If you want to have the Postgres server installed I would say you 
need to keep up with the minor version releases of whatever Postgres 
version you have installed. For example for Postgres 16 that would be 
16.4. If I remember correctly that will update the pgAdmin4 version.



-- 
Adrian Klaver
adrian.klaver@aklaver.com