Apt install postgresql

apt install postgresql

PostgreSQL 12

apt install postgresql 
.../...
After this operation, 112 MB of additional disk space will be used.
.../...
Success. You can now start the database server using:

    pg_ctlcluster 12 main start

PostgreSQL 10

Success. You can now start the database server using:

   /usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/main -l logfile start

Verify status

systemctl status postgresql.service
● postgresql.service - PostgreSQL RDBMS
   Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
   Active: active (exited) since Tue 2020-03-03 16:41:41 +04; 4min 8s ago
 Main PID: 30212 (code=exited, status=0/SUCCESS)
    Tasks: 0 (limit: 4915)
   CGroup: /system.slice/postgresql.service

Jun 03 16:41:41 SERVER_NAME systemd[1]: Starting PostgreSQL RDBMS...
Jun 03 16:41:41 SERVER_NAME  systemd[1]: Started PostgreSQL RDBMS.

systemctl status postgresql.service
● postgresql.service - PostgreSQL RDBMS
     Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
     Active: active (exited) since Sun 2021-02-07 11:50:24 +04; 3min 6s ago
   Main PID: 27775 (code=exited, status=0/SUCCESS)
      Tasks: 0 (limit: 4683)
     Memory: 0B
     CGroup: /system.slice/postgresql.service

Feb 07 11:50:24 SERVER_NAME systemd[1]: Starting PostgreSQL RDBMS...
Feb 07 11:50:24 SERVER_NAME systemd[1]: Finished PostgreSQL RDBMS.

Connect:

• sudo -u postgres psql

Related commands

• psql
• su - postgres

See also

• PostgreSQL: pg_dump, pg_restore, pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB, Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs, postgresql.conf, pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user, createdb, GRANT, pg_stat, PostgreSQL VACUUM, EXPLAIN, pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL), EXPLAIN ANALYZE, Bitmap scan, EXPLAIN VERBOSE, EXPLAIN VERBOSE (PostgresSQL), WAL, ALTER USER, CREATE ROLE, CREATE USER, \du, show users, \l, The Statistics Collector, pganalyze, cron.schedule, Master, pg_tables, PostgreSQL replication, CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users, catalogs