PostgreSQL

De Banane Atomic
Aller à la navigationAller à la recherche

Links

Installation

Bash.svg 
# will install postgresql-libs, postgresql and create a system user called postgres
sudo pacman -S postgresql

Initial configuration

Bash.svg 
# switch to the PostgreSQL user
sudo -iu postgres

# initialize the database cluster
initdb -D /var/lib/postgres/data
# $LANG (en_US.UTF-8) is used to deduce the locale and the encoding
# or can be defined manually: --locale=en_US.UTF-8 -E UTF8
Récupérée de « http://wiki.bananeatomic.fr/index.php?title=PostgreSQL&oldid=25571 »