DBS-PostgreSQL
Purpose
This stack provides PostgreSQL and PgWeb. PostgreSQL is a comprehensive Object-Relational Database Management System (ORDBMS). PgWeb acts as its convenient Web user interface.
Properties
| Stack-Description | PostgreSQL Database System (DBS) |
|---|---|
| Stack-Image | docker.msg.team/ps/docker-stack-dbs-postgresql |
| Stack-Version | 13.13 |
| Stack-Release | 20231130 |
| Product-Name | PostgreSQL & PgWeb |
| Product-Vendor | PostgreSQL Group & Dan Sosedoff |
| Product-Contact | https://www.postgresql.org/ |
| Product-Model | Open Source |
| Product-License | BSD & MIT |
| Product-Limits | none |
| Implementation Base | C\GO |
| Execution Base | Operating system - OS, Webserver |
| Initial Start Time | 00:00:23 |
| Documentation | https://www.postgresql.org/docs/ |
Topology
The stack consists of 2 containers:
- dbs-postgresql-fe: Frontend
- dbs-postgresql-be: Backend
Configuration
| Variable Name | Default | Meaning | |
See also the variables which control integration of the stack into the reverse proxy.
For changes to take effect the stack has to be reinstalled.
First Steps
After installing PostgreSQL on your server, please click on the PostgreSQL-pane in the webview of your server. You will get a login dialog from pgweb.
Host/User/Password: postgresql
After press "Connect", gratulation, you will see the startpage from PostgreSQL.
There is a lot of information on the web for the first steps, if you are a beginner.
4 Hour Beginners Tutorial https://www.youtube.com/watch?v=Jdi0uEWaRkc or check https://www.postgresqltutorial.com/
Administration Commands
| Command | Arguments | Function | |
| docker-stack exec std-postgresql psql | Cli for PostgreSQL |
Related Documents