« PostgreSQL » : différence entre les versions

De Banane Atomic
Aller à la navigationAller à la recherche
Ligne 50 : Ligne 50 :
sudo -iu postgres
sudo -iu postgres


# initialize the database cluster
# initialize the database cluster (postgres user)
initdb -D /var/lib/postgres/data
initdb -D /var/lib/postgres/data
# $LANG (en_US.UTF-8) is used to deduce the locale and the encoding
# $LANG (en_US.UTF-8) is used to deduce the locale and the encoding
Ligne 60 : Ligne 60 :
sc-start postgresql.service
sc-start postgresql.service


# create a user
# login (postgres user)
psql
 
# create a user (postgres 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.
# 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
createuser --interactive


# create a database
# create a database (postgres user)
createdb dbtest
createdb dbtest
# login
# login (current user)
psql -d dbtest
psql -d dbtest
</kode>
</kode>

Version du 23 mai 2023 à 21:54

Links

Database

Bash.svg
# create a database
createdb myDatabaseName

# connect to a database
psql -d myDatabaseName
Pgsql.svg
-- connect to a database
\c myDatabaseName

Table

Pgsql.svg
-- show summary information about all tables in the current database
\dt

Users and permissions

Pgsql.svg
-- list all users and their permission levels
\du

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
# create the cluster directory if needed
sudo mkdir /var/lib/postgres
sudo chown postgres:postgres /var/lib/postgres

# switch to the PostgreSQL user
sudo -iu postgres

# initialize the database cluster (postgres user)
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:
initdb --locale=C.UTF-8 --encoding=UTF8 -D /var/lib/postgres/data --data-checksums
# --data-checksums enable data checksumming

# start the service
sc-start postgresql.service

# login (postgres user)
psql

# create a user (postgres 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

# create a database (postgres user)
createdb dbtest
# login (current user)
psql -d dbtest