OS/Postgesql Upgrade / DB-Migration auf sauerkraut noch nicht abgeschlossen #26

Closed
opened 2023-10-30 23:01:13 +01:00 by l.behm · 1 comment
Owner

Installation muss bereinigt werden

$ pg_lsclusters 
Ver Cluster Port Status                Owner     Data directory               Log file
9.6 main    5433 down,binaries_missing <unknown> /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log
11  main    5434 down,binaries_missing <unknown> /var/lib/postgresql/11/main  /var/log/postgresql/postgresql-11-main.log
13  main    5432 online                postgres  /var/lib/postgresql/13/main  /var/log/postgresql/postgresql-13-main.log
15  main    5435 online                postgres  /var/lib/postgresql/15/main  /var/log/postgresql/postgresql-15-main.log

Migrationsarbeiten werden Downtime für matrix, gitea erzeugen

Installation muss bereinigt werden ```bash $ pg_lsclusters Ver Cluster Port Status Owner Data directory Log file 9.6 main 5433 down,binaries_missing <unknown> /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log 11 main 5434 down,binaries_missing <unknown> /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log 13 main 5432 online postgres /var/lib/postgresql/13/main /var/log/postgresql/postgresql-13-main.log 15 main 5435 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log ``` Migrationsarbeiten werden Downtime für matrix, gitea erzeugen
l.behm added this to the Mitgliederversammlung 2023 milestone 2023-10-30 23:01:13 +01:00
l.behm added the
Priority
Medium
Kind/Security
Kind/Bug
Reviewed
Confirmed
labels 2023-10-30 23:01:13 +01:00
l.behm self-assigned this 2023-10-30 23:01:13 +01:00
l.behm added this to the IT-Infrastruktur project 2023-10-30 23:01:13 +01:00
Author
Owner

Im wesentlichen war es nur:

sudo pg_upgradecluster --method=upgrade --link 13 main

Natürlich muss man genau prüfen was man macht mit:

# list clusters
sudo pg_lsclusters

# connect to "active" cluster
sudo -u postgres psql
# connect to cluster on port 5435 (was empty v15)
sudo -u postgres psql -p 5435

# drop empty v15 cluster
sudo pg_dropcluster --stop 15 main

Für mehr Infos dazu siehe: https://manpages.debian.org/buster/postgresql-common/pg_upgradecluster.1.en.html

Im wesentlichen war es nur: ```bash sudo pg_upgradecluster --method=upgrade --link 13 main ``` Natürlich muss man genau prüfen was man macht mit: ```bash # list clusters sudo pg_lsclusters # connect to "active" cluster sudo -u postgres psql # connect to cluster on port 5435 (was empty v15) sudo -u postgres psql -p 5435 # drop empty v15 cluster sudo pg_dropcluster --stop 15 main ``` Für mehr Infos dazu siehe: https://manpages.debian.org/buster/postgresql-common/pg_upgradecluster.1.en.html
Sign in to join this conversation.
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: Krautspace/Unkraut#26
No description provided.