There already is a cluster "main" for 11 (since this is created by default on package installation). Ver Cluster Port Status Owner Data directory Log fileĩ.6 main 5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/ġ1 main 5433 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log Run pg_lsclusters, your 9.6 and 11 main clusters should be "online". Note: guide can be also used to upgrade PostgreSQL 10 version. In my case, I will be performing the upgrade from 9.6 to 11 version, so at the next steps, I will replace the 9.x version with the actual 9.6 version. Ii postgresql-contrib-9.6 additional facilities for PostgreSQL Ii postgresql-common PostgreSQL database-cluster manager Ii postgresql-client-common manager for multiple PostgreSQL client versions Ii postgresql-client-9.6 front-end programs for PostgreSQL 9.6 Ii postgresql-client-11 front-end programs for PostgreSQL 11 Ii postgresql-9.6 object-relational SQL database, version 9.6 server Use dpkg -l | grep postgresql to check which versions of postgres are installed: ii postgresql-11 object-relational SQL database, version 11 server # install and launch the postgresql service:
RELEASE= $(lsb_release -cs ) echo "deb $ "-pgdg main | sudo tee /etc/apt//pgdg.list # add repository contents to your system: # install **wget** if not already installed:
0 kommentar(er)
