Difference between revisions of "Apt install postgresql"

From wikieduonline
Jump to navigation Jump to search
Line 51: Line 51:
 
== Related commands ==
 
== Related commands ==
 
* <code>[[psql]]</code>
 
* <code>[[psql]]</code>
 +
* <code>[[su - postgres]]</code>
  
 
== See also ==
 
== See also ==

Revision as of 22:49, 2 March 2022

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: