PostgreSQL

Links

• PostgreSQL on Archlinux
• pgAdmin

Database

# create a database createdb myDatabaseName # connect to a database psql -d myDatabaseName

-- connect to a database \c myDatabaseName

Table

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

Users and permissions

-- list all users and their permission levels \du

Service

sc-start postgresql.service

Installation

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

Configuration

# 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