Page History

...

Setting the port

TBD

Upgrading PostgreSQL

...

Servoy bundled version

...

TODO

...

EnterpriseDB installed version

...

Installing an update, lets say 9.0.1 to 9.0.2 literally means you just run the installer of 9.0.2 and you are done. Just make sure you stop Servoy (and any other client connecting to PostgreSQL) before you do this.

Upgrading PostgreSQL, lets say from 9.0.2 to 9.1, you can run the 9.1 installer and this will be installed next to the 9.0 installation. The installer automatically set the port of this version to one that doesn't collide with the one already installed. So the 2 versions can run at the same time.

Now to get your databases over to the new version you need to backup your whole database cluster using the command-line pg_dumpall backup utility and load it back into the new instance using the psql utility. You could also use PgAdmin for this.

It is recommended to use the tools from the newer version to backup the databases from the older version.

See the backup section on this page for more information on how to do backups and restores.

Starting and stopping PostgreSQL manually

...