Difference between revisions of "Apt install postgresql"
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
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
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: