If the version of a PostgreSQL server changes, it is required to upgrade the version manually. This can e.g. happen, if you do a release upgrade of your Linux distribution. The below description explains how to use PostgreSQL pg_upgradecluster to upgrade PostgreSQL 9.6 from Debian Stretch (Debian 9) to PostgreSQL 11 of Debian Buster (Debian 10).
Continue reading “PostgreSQL pg_upgradecluster”Category: Database
Hibernate UUID issues on Postgres 10
After updating a database from Postgres 9.6 to 10 all applications stopped working. The error message in the server log file is “Unable to load requested class: pg-uuid”.
PgModeler 0.9.0-alpha1 out
Developer Raphael Araújo e Silva released PgModeler 0.9.0-alpha1 on February 7th, 2017. See my previous post “install PgModeler from source” for manual installation. It also works with the 0.9.0-alpha1 release.
build PgModeler from source
PGModeler (http://www.pgmodeler.com.br) is a nice tool to design your (PostgreSQL) database. It supports import from and export to a databases. Ubuntu 15.10 comes with a quite recent version but e.g. Debian does not provide it in the repository. In this post I explain howto build the application on Linux (tested on Debian 8) from source.