Differences

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

--- computer:gentoo [2017-08-23 04:07] – 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
@@ Line 143: / Line 163: @@
 # It will NOT be updated and reflects only the
 # installation profile at installation time.
 selected_scheme scheme-custom
-TEXDIR /opt/texlive/2017
-TEXMFCONFIG ~/.config/texlive2017
+TEXDIR          /opt/texlive/2017
-TEXMFHOME ~/texmf
+TEXMFSYSCONFIG  /opt/texlive/2017/texmf-config
-TEXMFLOCAL /opt/texlive/texmf-local
+TEXMFSYSVAR     /opt/texlive/2017/texmf-var
-TEXMFSYSCONFIG /opt/texlive/2017/texmf-config
+TEXMFLOCAL      /opt/texlive/texmf-local
-TEXMFSYSVAR /opt/texlive/2017/texmf-var
-TEXMFVAR ~/.cache/texlive2017
+TEXMFCONFIG     ~/.config/texlive2017
+TEXMFVAR        ~/.cache/texlive2017
+TEXMFHOME       ~/texmf
 binary_x86_64-linux 1
 collection-basic 1
@@ Line 176: / Line 201: @@
 collection-publishers 1
 collection-xetex 1
 instopt_adjustpath 0
 instopt_adjustrepo 1
@@ Line 181: / Line 207: @@
 instopt_portable 0
 instopt_write18_restricted 1
 tlpdbopt_autobackup 1
 tlpdbopt_backupdir tlpkg/backups