Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to upgrade pgAdmin 4 on windows?

I installed pgAdmin 4 as part of the postgres installer for Windows. pgAdmin is now telling me there is a newer version (4.8, > 4.5 which I have). However, there is no built in upgrade functionality that I can see, and when I went to download and run the pgAdmin 4 installer to upgrade, it installed itself in the wrong place, leading to problems.

At first I tried installing it to the default location (C:\Program Files (x86)\pgAdmin 4\v4), which was incorrect, because the previous installation (from the postgres installer) went to a different location (C:\Program Files\PostgreSQL\11\pgAdmin 4).

The second time, I pointed it to my existing install of postgres (C:\Program Files\PostgreSQL\11\pgAdmin 4), but it installed itself to a subdirectory there instead (C:\Program Files\PostgreSQL\11\pgAdmin 4\v4), rather than upgrading the existing installation, once again yielding to duplicated installations and problems arising from that. I assume if I go download the postgres installer, it will just reinstall version 4.5 of pgAdmin, though I have not tested this.

What is the correct method for upgrading a pgAdmin instance originally installed by the postgres Windows installer?

like image 539
Anomaly Avatar asked Jun 05 '19 13:06

Anomaly


People also ask

How do I update pgAdmin4 on Windows?

Installation Steps Download the latest version of pgAdmin 4 here and start the installation. It will first prompt us to a dialog where we can select the installation folder. By default, it will offer us to install pgAdmin 4 in C:\Program Files (x86).

What is the latest version of pgAdmin?

2022-10-20 - pgAdmin 4 v6.15 Released. The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.15. This release of pgAdmin 4 includes 35 bug fixes and new features. For more details please see the release notes.

How do I open pgAdmin4 on Windows?

To open pgAdmin, select pgAdmin4 from the EDB Postgres menu. The client opens in your default browser. To connect to the Advanced Server database server, expand the Servers node of the Browser tree control, and right click on the EDB Postgres Advanced Server node. When the context menu opens, select Connect Server .


2 Answers

I think the best option is to go to "Program and files" -> Select "PostgreSQL" and "Uninstall". Uninstaller will you ask you if you want to uninstall the whole application or only individual components. Select individual components and then select "pgAdmin". This will uninstall pgAdmin from PostgreSQL directory. From now install the latest version pgAdmin only from official website which will install it into: C:\Program Files (x86)\pgAdmin 4\v4

like image 189
Mikołaj Waśniewski Avatar answered Sep 22 '22 03:09

Mikołaj Waśniewski


If you Download the installer from here https://www.postgresql.org/ftp/pgadmin/pgadmin4/v4.8/windows/

It should automatically install the 4.8 version in (C:\Program Files (x86)\pgAdmin 4\v4) overwriting any existing 4.x version but keeping your server connections and setting.

In your case, the previous install was in a different place, therefore, you ended up having 2 versions.

What I suggest to you is go to control panel and uninstall from there all the versions you have. After that go to the above link, download and install the v4.8 in the default location. Every time there is a new version available just install it and let the installer install it on the default location.

Please note that your pgadmin server connections can be found in %appdata%\pgAdmin.

Note that I have personally just upgraded from v4.5 to v4.8 using this method (installing it in the default location) and it worked like a charm.

like image 32
Claudio Corchez Avatar answered Sep 20 '22 03:09

Claudio Corchez