diff options
Diffstat (limited to 'system/postgresql16')
| -rw-r--r-- | system/postgresql16/README.SBo | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/system/postgresql16/README.SBo b/system/postgresql16/README.SBo index 987f648ef6..917383c832 100644 --- a/system/postgresql16/README.SBo +++ b/system/postgresql16/README.SBo @@ -41,7 +41,7 @@ A few hints for PostgreSQL 15.x -> 16.x upgrade: # su postgres -c "initdb -D /var/lib/pgsql/16/data --locale=en_US.UTF-8 -A md5 -W" - Adjust the pg_hba.conf in postgresql 16 to allow postgres user to connect - Run pg_upgrade (as postgres user) - $ pg_upgrade --old-datadir /var/lib/pgsql/15/data/ --new-datadir /var/lib/pgsql/16/data/ --old-bindir /usr/lib64/postgresql/15/bin/ --new-bindir /usr/lib64/postgresql16/16/bin/ -U postgres + $ pg_upgrade --old-datadir /var/lib/pgsql/15/data/ --new-datadir /var/lib/pgsql/16/data/ --old-bindir /usr/lib64/postgresql15/15/bin/ --new-bindir /usr/lib64/postgresql16/16/bin/ -U postgres - Start postgresql 16 service - Optionally, vacuum all database /usr/lib{64}/postgresql16/16/bin/vacuumdb -U postgres --all --analyze-in-stages |