http://192.168.180.206:8001/ 2026-05-13T04:14:29+00:00 http://192.168.180.206:8001/ http://192.168.180.206:8001/_media/wiki:dokuwiki.svg text/html 2024-09-09T08:06:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://192.168.180.206:8001/linux:databases:psql:backup?rev=1725869217&do=diff backup * Convert binary dump to SQL pg_restore -f database.sql database.pgdump text/html 2023-07-28T10:07:47+00:00 Anonymous (anonymous@undisclosed.example.com) http://192.168.180.206:8001/linux:databases:psql:issues?rev=1690538867&do=diff issues invalid primary checkpoint record After unclean shutdown: user=,db=,app=,client= LOG: invalid primary checkpoint record user=,db=,app=,client= PANIC: could not locate a valid checkpoint record Postgresql running from official docker container. text/html 2024-09-09T08:09:45+00:00 Anonymous (anonymous@undisclosed.example.com) http://192.168.180.206:8001/linux:databases:psql:performance?rev=1725869385&do=diff performance log slow queries log_min_duration_statement=10000 sudo systemctl reload postgresql text/html 2021-10-11T08:54:35+00:00 Anonymous (anonymous@undisclosed.example.com) http://192.168.180.206:8001/linux:databases:psql:tuning?rev=1633942475&do=diff postgresql tuning * If the database resides on a Btrfs file system, you should consider disabling Copy-on-Write for the directory before creating any database. * If the database resides on a ZFS file system, you should consult ZFS hints for databases before creating any database. text/html 2025-03-30T18:58:16+00:00 Anonymous (anonymous@undisclosed.example.com) http://192.168.180.206:8001/linux:databases:psql:upgradeto12to13?rev=1743361096&do=diff docker upgrade 12 to 13 Stop all services. Add new service with PGSQL v13 services: db: container_name: db image: postgres:12-alpine db13: container_name: db13 image: postgres:13-alpine Start only DB services: docker compose up db db13 -d text/html 2021-10-11T10:05:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://192.168.180.206:8001/linux:databases:psql:upgradeto13?rev=1633946757&do=diff Upgrade to 13 su postgres /usr/lib/postgresql/13/bin/vacuumdb -p 45432 --all --analyze-in-stages /usr/lib/postgresql/13/bin/vacuumdb -p 45432 --all --full text/html 2025-05-20T05:37:49+00:00 Anonymous (anonymous@undisclosed.example.com) http://192.168.180.206:8001/linux:databases:psql:upgradeto15?rev=1747719469&do=diff Upgrade to 15 During updating to Debian 12, installer left postgresql-13 with info to manually upgrade. apt install postgresql-15 pg_dropcluster --stop 15 main pg_upgradecluster 13 main # OR if upgrading from Debian 10 # pg_upgradecluster 11 main Success. Please check that the upgraded cluster works. If it does, you can remove the old cluster with pg_dropcluster 11 main text/html 2025-11-07T18:18:53+00:00 Anonymous (anonymous@undisclosed.example.com) http://192.168.180.206:8001/linux:databases:psql:upgradeto17?rev=1762539533&do=diff Upgrade to 17 sudo apt install curl ca-certificates sudo install -d /usr/share/postgresql-common/pgdg sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc . /etc/os-release sudo sh -c "echo 'deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $VERSION_CODENAME-pgdg main' > /etc/apt/sources.list.d/pgdg.list" sudo apt update