Hi,
I’m toying with the idea of moving from the version of Postgres that comes with Servoy to the “regular” version of Postgres. I believe it’s called the Enterprise version.
Why? I’m not entirely sure, other than the ability to move to newer versions of Postgres before Servoy might want to. There’s something in Postgres 9.1 that I’d like to explore, for example, but I think that Servoy is on 9.0.3.
If I move to the external version of Postgres, does that affect the build that gets done when I create a Servoy runtime version of my application?
Now, I think that if I install the enterprise version of Postgres while Servoy is active (and therefore so is the embedded version of Postgres), the new install will mostly likely grab the next port, 5433. If I do that, then I think all I have to do is set up the database connection to point at port 5433, and I should be ok? Is that correct? That way, I think I could still keep the embedded version around in case I want to switch back after I see how things work out.
And then, to move my existing database that’s in the embedded version to the enterprise version, all I’d have to do is a backup and restore.
Am I thinking about this correctly?
As always, I appreciate any guidance you might be able to provide.
Thanks and have a good day.
Ron