Difference between revisions of "Apt install postgresql"
Jump to navigation
Jump to search
Line 17: | Line 17: | ||
− | Verify status | + | === Verify status === |
<pre> | <pre> | ||
systemctl status postgresql.service | systemctl status postgresql.service |
Revision as of 18:11, 3 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
- 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
Advertising: