Differences

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

--- computer:gentoo [2017-12-09 01:33] – skrupellos
+++ computer:gentoo [2023-03-05 14:01] (current) – [PostgreSQL] skrupellos
@@ Line 72: / Line 72: @@
   * Copy config files from ''/etc/postgresql-*/'' to ''/var/lib/postgresql/*/data/'' (they are now symlinked)
   * Add ''local  all  all  trust'' to ''/etc/postgresql-*/pg_hba.conf'' (it it there by default)
+=== Arch Linux Version ===
+<code>
+systemctl stop postgresql
+systemctl status postgresql
+cd /var/lib/postgres
+V=$(cat data/PG_VERSION)
+mv data data-$V
+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 -- pg_upgrade -b /opt/pgsql-$V/bin -B /usr/bin -d ../data-$V -D ../data
+systemctl start postgresql
+systemctl status postgresql
+sudo -u postgres -- vacuumdb --all --analyze-in-stages
+cd ..
+rm -R tmp
+</code>
 ===== Haushalten =====
 Konfiguration in ''/etc/portage/'' überprüfen