« PostgreSQL » : différence entre les versions

De Banane Atomic
Aller à la navigationAller à la recherche
Aucun résumé des modifications
Ligne 2 : Ligne 2 :
= Links =
= Links =
* [https://wiki.archlinux.org/index.php/PostgreSQL PostgreSQL on Archlinux]
* [https://wiki.archlinux.org/index.php/PostgreSQL PostgreSQL on Archlinux]
= Database =
<kode lang='bash'>
# create a database
createdb myDatabaseName
# connect to a database
psql -d myDatabaseName
</kode>
<kode lang='postgresql'>
# connect to a database
\c <database>
</kode>


= Service =
= Service =

Version du 4 avril 2021 à 17:44

Links

Database

Bash.svg
# create a database
createdb myDatabaseName

# connect to a database
psql -d myDatabaseName
Fichier:Postgresql.svg
# connect to a database
\c <database>

Service

Bash.svg
sc-start postgresql.service

Installation

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

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

# start the service
sc-start postgresql.service

# create a user
# If the new user has the same name as your Linux user, it allows you to access the PostgreSQL database shell without having to specify a user to login.
createuser --interactive