Differences

This shows you the differences between two versions of the page.

--- computer:gentoo [2021-01-01 20:40] – [PostgreSQL] skrupellos
+++ computer:gentoo [2026-01-24 21:11] (current) – [PostgreSQL] skruppy
@@ Line 84: / Line 84: @@
 install -d -o postgres -g postgres -m 700 /var/lib/postgres/{data,tmp}
 cd tmp
-sudo -u postgres -- initdb --locale en_US.UTF-8 --encoding=UTF8 -D ../data
+sudo -u postgres -- initdb --locale C.UTF-8 --encoding=UTF8 -D ../data
 sudo -u postgres -- pg_upgrade -b /opt/pgsql-$V/bin -B /usr/bin -d ../data-$V -D ../data
 systemctl start postgresql
 systemctl status postgresql
-sudo -u postgres ./analyze_new_cluster.sh
+sudo -u postgres -- vacuumdb --all --analyze-in-stages
 cd ..
 rm -R tmp