Re: Switch PG Versions

2021-03-04 Thread richard coleman
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

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

RES: Switch PG Versions

2021-03-04 Thread Edson Richter
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

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

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

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?

RES: Switch PG Versions

2021-03-04 Thread Edson Richter
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

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

Re: Help installing on Mac

2021-03-04 Thread Anthony DeBarros
In pgAdmin, in the Object Browser, right-click Servers, and choose Create > Server. In the dialog, type a name for your server in the General tab. On the Connection tab, in the Host name/address box, type localhost. Fill in your user name and the password you supplied when installing PostgreSQL,

Help installing on Mac

2021-03-04 Thread Jackie Culver
Hi there, I have downloaded PGAdmin4 and Postgres on my Mac OS Big Sur. When. I open PgAdmin 4 I cannot seem to connect a server. How do I set this up? Thank you! Jackie

Re: Save results in CSV

2021-03-04 Thread Kay Khandpur
Thanks! On Wed, Mar 3, 2021 at 8:41 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi, > > On Thu, Mar 4, 2021 at 10:08 AM Kay Khandpur wrote: > >> Thanks Aditya! >> >> So it looks like I got used to a feature that was actually a bug.  >> >> Any suggestions on how to

Re: RES: Switch PG Versions

2021-03-04 Thread Jack Royal-Gordon
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 wrote: > > Exactly what I said: I was just being enfatic about the risk. > From OP, I felt he wants to