PostgreSQL server installation

• 01 September 2020
• by: sedlav
• in: Databases
• Tags: postgresql
• note: no comments

PostgreSQL is a powerful object-relational database system with more than 30 years of active development that has gained a high reputation for reliability, robustness and performance.

PostgreSQL is a powerful object-relational database system with more than 30 years of active development that has gained a high reputation for reliability, robustness and performance.

Install

$ sudo apt install postgresql

After the installation is finished, we verify if the PostgreSQL server is running.

Check status

$ sudo systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Tue 2019-05-07 21:20:41 EDT; 20min ago
Process: 2620 ExecStart=/bin/true (code = exited, status = 0 / SUCCESS)
Main PID: 2620 (code = exited, status = 0 / SUCCESS)

May 07 21:20:41 debian systemd [1]: Starting PostgreSQL RDBMS ...
May 07 21:20:41 debian systemd [1]: Started PostgreSQL RDBMS.

Connect to the server

$ sudo -u postgres psql
psql (9.6.12)
Type "help" for help.
postgres = #

exit from the Postgres console

\ q

Stop the Postgres server

 $ sudo systemctl stop postgresql 

Start the Postgres server

$ sudo systemctl start postgresql