Re: Switch PG Versions

Thanks, Dave. I did eventually figure out how to add another server to postgres.app. The whole process was very easy, although rather well-hidden. BTW, it was very easy to reconfigure in pgAdmin4 — but maybe add drag-and-drop to copy databases between servers? ;)

Jack

> On Mar 4, 2021, at 3:29 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
> EDB installers are designed to support side by side installation of multiple major versions. It works just fine (I’ve been using them like that for years).
>
> On Thu, 4 Mar 2021 at 23:22, Jack Royal-Gordon <jackrg(at)pobox(dot)com <mailto:jackrg(at)pobox(dot)com>> wrote:
> Thanks, Richard. Honestly, I’d prefer to get it going with the EDB distribution that I already have, but I’m very comfortable with Homebrew so your approach will definitely be my fallback if I can’t do it with EDB.
>
>> On Mar 4, 2021, at 12:49 PM, Richard Brockie <richard(dot)brockie(at)gmail(dot)com <mailto:richard(dot)brockie(at)gmail(dot)com>> wrote:
>>
>> 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/>
>
> --
> --
> Dave Page
> https://pgsnake.blogspot.com <https://pgsnake.blogspot.com/>
>
> EDB Postgres
> https://www.enterprisedb.com <https://www.enterprisedb.com/>