The last post looked into how to upgrade PostgreSQL to a new minor version. We are making PostgreSQL 9. This is to allow users to upgrade as soon as possible to the new . Upgrade postgresql on Debian Jessie with pg_upgradecluster So you just upgraded to Debian Jessie, and now how do you upgrade postgres. Tue Apr 11:20:adminuser@serverbox var/db/ postgres ] sudo service postgresql initdb The files belonging to this database system will be . Before you procee make sure you are logged in as a Postgres user with super powers.
In Ubuntu, switching to postgres user is enough: sudo . Unfortunately that means that my PostgreSQL database was at version 9. So can you upgrade from . The problem is that the postgis extension version in the old cluster is not the same as the library version in the new one. So when it tries to migrate the database, . Backup all databases; Remove the current postgresql ; Install postgresql84; Start the new PostgreSQL ; Check if you have any issues .
No comments:
Post a Comment
Note: only a member of this blog may post a comment.