Version v1.5.1 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.

PGWeb

Historical documentation restored from the Pigsty v1.5.1 tag.

Historical Docs

PIGSTY

Pigsty v1.5.1 does not ship the former infra-pgweb.yml playbook or the pgweb_enabled / pgweb_username inventory parameters. PGWeb is provided as a Docker application at app/pgweb.

Run PGWeb

Docker is enabled on the meta node in the bundled v1.5.1 inventory. Start the tagged PGWeb application with:

cd ~/pigsty/app/pgweb
docker-compose up -d

The tagged Compose file maps host port 8886 to container port 8081. Supply a database connection string in the PGWeb interface, for example postgres://dbuser_dba:[email protected]:5432/meta after replacing the credentials as appropriate.

To expose it through Nginx, add an nginx_upstreams entry for 127.0.0.1:8886 and rerun ./infra.yml -t nginx_config,nginx_restart. See Docker Applications for the frozen v1.5.1 application context.