Assistenza

Benvenuto!

Questa comunità è per professionisti ed entusiasti dei nostri prodotti e servizi.
Condividi e discuti i migliori contenuti e le nuove idee di marketing, crea il tuo profilo personale e diventa insieme a noi un promotore migliore.

0

Upgrade Postgres

Avatar
Administrator

Open

Add the PostgreSQL package repository on your linux machine

echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main 11" | tee /etc/apt/sources.list.d/pgsql.list

Add the GPG key of the PostgreSQL package repository

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -

Update sources and install new postgres version

apt update && postgresql-12 postgresql-server-dev-12

Stop all postgres instances running

systemctl stop postgresql.service

Run the upgrade

/usr/lib/postgresql/12/bin/pg_upgrade -v -d /etc/postgresql/9.6/main -D /etc/postgresql/12/main/ -b /usr/lib/postgresql/9.6/bin/ -B /usr/lib/postgresql/12/bin/

Here change port to 5432

vim /etc/postgresql/12/main/postgresql.conf

 Start postgres service

systemctl start postgresql.service


If needed remove old postgres

Check installed postgres

apt list --installed | grep postgresql

Remove old version from folder

rm -rf /etc/postgresql/11/


Disable postgres version from run

/etc/postgresql/9.1/main/start.conf

Change from auto to disable. See here 


Avatar
Abbandona