Thanks for the warning, Edson. I wasn’t planning on sharing data folders (I just assumed that wouldn’t work), but nevertheless it’s good to know.
> On Mar 4, 2021, at 4:38 PM, Edson Richter <edsonrich...@hotmail.com> wrote: > > Exactly what I said: I was just being enfatic about the risk. > From OP, I felt he wants to interchange installs (in my mind, by using same > data directory). > It’s ok to do that, being careful of not sharing data files. > > But your explanation made all clear. > > Regards, > > Edson > > > Enviado do Email <https://go.microsoft.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 > <mailto:pgadmin-support@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 example, a Windows > machine running versions 10, 12, and 13 would have a default file structure > like this; > C:\Program Files\PostgreSQL\10\... (various folders including data, where > your database data resides) > C:\Program Files\PostgreSQL\12\... (various folders including data, where > your database data resides) > C:\Program Files\PostgreSQL\13\... (various folders including data, where > your database data resides) > As you can see, as long as the data folders for each postgreSQL version are > kept in different locations and you are running postgreSQL on different > ports, you can run as many copies of postgreSQL in parallel as you have > resources (hard drive space, memory, CPU, etc.). Things only get tricky when > you want to run multiple instances of the same version of postgreSQL on the > same machine for some reason. In this case you would have to deviate from > the default folder structure. If you wanted to run three copies of > postgreSQL 13 on the same machine in parallel then something like this would > do; > C:\Program Files\PostgreSQL\13\... (various folders including data, where > your database data resides) > C:\Program Files\PostgreSQL\13a\... (various folders including data, where > your database data resides) > C:\Program Files\PostgreSQL\13b\... (various folders including data, where > your database data resides) > Of course, you would need to go back through your configuration files to make > sure they matched your alternative layout. You would also still need to be > running them on different ports. > > I hope that helps, > > rik. > > > On Thu, Mar 4, 2021 at 4:03 PM Edson Richter <edsonrich...@hotmail.com > <mailto:edsonrich...@hotmail.com>> wrote: > 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 > > <D786478EAE31496FB95FB225147CAEE0.png> > De: Richard Brockie <richard.broc...@gmail.com > <mailto:richard.broc...@gmail.com>> > Enviado: Thursday, March 4, 2021 5:49:05 PM > Para: pgadmin-support lists.postgresql.org <http://lists.postgresql.org/> > <pgadmin-support@lists.postgresql.org > <mailto:pgadmin-support@lists.postgresql.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 <jac...@pobox.com > <mailto:jac...@pobox.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/>
