Hi,
I would like to upgrade PosgreSQL to the new version. Could you please tell me the steps?
Thanks in advance.
Hi,
Do you want to upgrade your PostgreSQL instance that came with Servoy or did you used one of the third party installers ?
In either case you do need to use PgAdmin (or the commandline tool pg_dumpall) to backup your whole cluster. This you can later load into the new upgraded instance.
As for the newer version (9.0.x) you need to use a third party installer in this case. Servoy doesn’t come with 9.0.x (yet). I suggest you use the EnterpriseDB installer for this.
Hope this helps
Hi Ronert. I’m using the postgreSQL that came with Servoy
I have pgAdmin and want to upgrade to version 9
I must be really clumsy but I´m not able to upgrade to version 9.
Maybe it is because I do not know the behind the scenes when Servoy is installed. I do not know where the database and data is kept and so on.
At the same time I have tried to backup the DB server (Servoy (localhost:5432)) but I do not find the option to restore it.
I guess that I will have to wait until Servoy comes with PostgreSQL 9
Juan,
do you want to run Postgres v9 as a stand alone server and not as part of the Servoy install?
If yes then you should read up on the installation instructions in the postgres site or the third party installer EnterpriseDB. (Search this forum for Postgres and see if the answer is there).
If you want to upgrade the v9 Postgres but have it installed the way that the Servoy supplied Postgres 8.4 works then you will have to examine how it is installed now and replicate that.
Ensure that the jdbc driver is replaced (the one that comes with Servoy) when you do upgrade with a compatible version from the Postgres website.
I did the stand alone installation and managed to replicate all the databases that come with Servoy sample solutions to be on the stand alone server rather than the Servoy Supplied server, including the repository (this would be for a brand new installation, no solutions imported). This was not as straight forward as I had hoped but I did learn a lot on the way.
If the existing Servoy supplied Postgres server is sufficient for your purposes then perhaps it is best to wait until Servoy upgrades to a later release.
Hi Juan,
jasantana:
I must be really clumsy but I´m not able to upgrade to version 9.Maybe it is because I do not know the behind the scenes when Servoy is installed. I do not know where the database and data is kept and so on.
Servoy’s Pg instance has it’s database cluster in /application_server/database/ . But you shouldn’t have to look in there to get your data. Actually it’s not recommended to touch any of those files (other than the .conf files).
If you installed PostgreSQL 9.0.x with the EDB installer then your database cluster is located in /Library/PostgreSQL/9.0/data/ (Mac) or C:\Program Files\PostgreSQL\9.0\data\ (windows).
jasantana:
IAt the same time I have tried to backup the DB server (Servoy (localhost:5432)) but I do not find the option to restore it.
When you backup the whole cluster then you get a backup file in plain SQL. You need to run this in a query editor. The best way to do this is with the command-line tool psql.
psql -f /path/to/your/backup/file.sql postgres postgres
This will connect you to the ‘postgres’ database with the user ‘postgres’, executes the sql file and then exits.
jasantana:
I guess that I will have to wait until Servoy comes with PostgreSQL 9
In either case you need to migrate your data from one Pg version to the other. Unless of course you want to start from scratch.
Hope this helps.