Difference between revisions of "Apt install postgresql"

From wikieduonline
Jump to navigation Jump to search
Line 12: Line 12:
 
     [[pg_ctlcluster]] 12 main start
 
     [[pg_ctlcluster]] 12 main start
  
=== [[PostgreSQL 10]] ===
+
== [[PostgreSQL 10]] ==
 
  Success. You can now start the database server using:
 
  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
 
     /usr/lib/postgresql/10/bin/[[pg_ctl]] -D /var/lib/postgresql/10/main -l logfile start
 
  
 
=== Verify status ===
 
=== Verify status ===

Revision as of 11:37, 20 April 2022

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

See also

Advertising: