Postgres¶
Manage PostgreSQL users, databases, schemas, extensions, connections, locks, indexes, and replication.
Users table with roles, privileges, and connection counts.
KeePass¶
Path: postgres/<env>/<instance>
| Field | Meaning |
|---|---|
| URL | host |
| UserName / Password | credentials |
port |
default 5432 |
database |
default postgres |
sslmode |
default disable (require, verify-full, …) |
tags |
tags |
omo secrets put postgres/development/local \
--url localhost \
--username omo \
--password omo \
--attr port=5432 \
--attr database=omo \
--attr sslmode=disable
Views¶
| Key | View |
|---|---|
| 0 | Users |
| 1 | Databases |
| 2 | Tables |
| 3 | Schemas |
| 4 | Extensions |
| 5 | Connections |
| 6 | Stats |
| 7 | Config |
| 8 | Locks |
| 9 | Indexes |
More views¶
| Key | View |
|---|---|
| ++Y++ | Replication |
| ++T++ | Tablespaces |
| ++B++ | DB Stats |
Actions (highlights)¶
| View | Keys |
|---|---|
| Users | ++N++ new · ++D++ drop · ++P++ password · ++G++ grant · ++V++ revoke |
| Databases | ++S++ switch · ++N++ create · ++D++ drop |
| Tables | ++E++ columns |
| Extensions | ++N++ install · ++D++ drop |
| Connections | ++K++ kill · ++C++ cancel query |
| Config | ++E++ edit param |
| Indexes | ++E++ index definition |
Tags¶
database · sql · monitoring