Sie an Alle 18:26 (Bearbeitet) In Ubuntu 22: 1. Create a new database with the desired Version : 1.1 Install prerequisites sudo apt update sudo apt install gpgv gpgsm gnupg-l10n gnupg dirmngr 1.2 Import the PostgreSQL signing key, add the PostgreSQL apt repository and install PostgreSQL. sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' sudo wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt update sudo apt -y install postgresql-16 postgresql-client-16 postgresql-contrib-16 oder einfach nur sudo apt -y install postgresql-16 postgresql-contrib-16
Sie an Alle 18:30 (Bearbeitet) 2. When you have installed postgres 16, migrate the data like this systemctl stop PostgreSQL su - postgres pg_upgrade -b /usr/lib/postgresql/12/bin -B /usr/lib/postgresql/16/bin -d /var/lib/postgresql/12/main -D /var/lib/postgresql/16/main -o '-c config_file=/etc/postgresql/12/main/postgresql.conf' -O '-c config_file=/etc/postgresql/16/main/postgresql.conf' -p 5432 -P 5433 --check --verbose [ -U postgresql ] First run with --check, then without --check
Sie an Alle 18:32 (Bearbeitet) when I install postgres 16, it runs on port 5433, while postgres 12 is on the [Standard] postgres port 5432. After the Migration (pg_upgrade), remove postgres 12 and switch postgres 16 to port 5433.
Sie an Alle 18:33 3. uninstall postgres 12: sudo apt-get --purge remove sudo apt-get --purge remove postgresql-12
Sie 18:43 After step 1.2 and before step 2. you have to do: 1.3 Do everything for postgres 16 which you had done to configure postgres 12 before: Configure PostgreSQL to listen on all interfaces and allow connections from all addresses (to allow Docker connections).
cd /etc/postgresql/16/main Edit (via sudo) the file /etc/postgresql/16/main/postgresql.conf add line listen_addresses = '*' in the "Connection Settings" section. In the same file, increase max_connections = 1200 In the same file, change log_timezone and timezone, otherwise they will be UTC. Edit (via sudo) the file /etc/postgresql/16/main/pg_hba.conf to add line host all all 0.0.0.0/0 md5 Restart PostgreSQL with command sudo systemctl restart postgresql
Topics for next meetings
Action items
Type your task here, using "@" to assign to a user and "//" to select a due date