Re: RES: Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
ft.com/fwlink/?LinkId=550986> para > Windows 10 > > De: richard coleman <mailto:rcoleman.ascen...@gmail.com> > Enviado:quinta-feira, 4 de março de 2021 18:38 > Para: Edson Richter <mailto:edsonrich...@hotmail.com> > Cc:pgadmin-support lists.postgresql.org > <mai

Re: Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
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

RES: Switch PG Versions

2021-03-04 Thread Edson Richter
upport@lists.postgresql.org> Assunto: Re: Switch PG Versions Edson, Of course not. What you can do is install multiple versions of postgreSQL in parallel (I've done it on Windows and Ubuntu Server). It's why they are each put into their own version numbered directory. For exam

Re: Switch PG Versions

2021-03-04 Thread Dave Page
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 wrote: > Thanks, Richard. Honestly, I’d prefer to get it going with the EDB > distribution th

Re: Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
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 > wrote: > > Hi Jack, > > I wa

Re: Switch PG Versions

2021-03-04 Thread richard coleman
--- > *De:* Richard Brockie > *Enviado:* Thursday, March 4, 2021 5:49:05 PM > *Para:* pgadmin-support lists.postgresql.org < > pgadmin-support@lists.postgresql.org> > *Assunto:* Re: Switch PG Versions > > Hi Jack, > > I was in a similar situation with an old appli

RES: Switch PG Versions

2021-03-04 Thread Edson Richter
– this will lead to data loss. Regards, Edson Enviado do Email<https://go.microsoft.com/fwlink/?LinkId=550986> para Windows 10 De: Richard Brockie Enviado: Thursday, March 4, 2021 5:49:05 PM Para: pgadmin-support lists.postgresql.org Assunto: Re: Swi

Re: Switch PG Versions

2021-03-04 Thread Richard Brockie
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 singl

Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
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?