RES: Switch PG Versions

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgadmin-support lists(dot)postgresql(dot)org <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: RES: Switch PG Versions
Date: 2021-03-04 21:02:55
Message-ID: CP2P152MB0403566A845398C079B228A8CF979@CP2P152MB0403.LAMP152.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Yes it’s possible to do as Richard noticed. But you cannot share at any chance the data folder!
This will corrupt your data making irrecoverable.
Even not having two versions online, you cannot shutdown version 10 and startup version 12 (or any combination of major versions) on same data folder – this will lead to data loss.

Regards,

Edson

Enviado do Email<https://go.microsoft.com/fwlink/?LinkId=550986> para Windows 10

________________________________
De: Richard Brockie <richard(dot)brockie(at)gmail(dot)com>
Enviado: Thursday, March 4, 2021 5:49:05 PM
Para: pgadmin-support lists.postgresql.org <pgadmin-support(at)lists(dot)postgresql(dot)org>
Assunto: Re: Switch PG Versions

Hi Jack,

I was in a similar situation with an old application using pg v9. I installed different versions of postgres with homebrew on Catalina. I currently have versions 9, 11 & 12 installed and can have them all running in parallel listening on different ports. I connect to them all from a single instance of pgAdmin4 over their respective ports. Testing the application with the new pg version is also just a port change in the configuration. It works very well.

Best wishes,
R.

On Thu, Mar 4, 2021 at 11:52 AM Jack Royal-Gordon <jackrg(at)pobox(dot)com<mailto:jackrg(at)pobox(dot)com>> wrote:
I’m using the EDB PG installation on Mac OS 11.1 (Big Sur), which seems to offer multiple versions. I’m currently running PG10, but I’m looking to upgrade to PG13 and would like to test with it first. Can I (and if so then how do i) switch back and forth between PG versions?

--
R.

Richard Brockie

Real-time bicycle race management - www.ontheday.net<http://www.ontheday.net>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message richard coleman 2021-03-04 21:38:46 Re: Switch PG Versions
Previous Message Richard Brockie 2021-03-04 20:49:05 Re: Switch PG Versions