Fórum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    Postgres Installation

    Uživatelské návody
    1
    1
    9
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • raven2cz
      raven2cz last edited by

      Postgres Installation

      sudo pacman -S postgresql postgis
      sudo -u postgres -i
      initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data/'
      exit
      sudo systemctl enable --now postgresql.service
      #sudo systemctl start postgresql.service
      sudo su postgres
      psql --version
      psql
      # insert admin password
      \password
      \q
      sudo pamac install pgadmin4
      

      Upgrade databáze (pokud nejsou update scripts)

      Je nutné smazat :

      /var/lib/postgres/data/
      

      přidělit práva /var/lib/postgres/ pro user a skupinu postgres

      potom znovu vytvořit databáze repository:

      initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data/'
      

      pak již znovu nahodit server.

      1 Reply Last reply Reply Quote 0
      • 1 / 1
      • First post
        Last post