Skip to content

PostgreSQL Local (postgres://)

Postgres.app Logo

Overview

The PostgreSQL Local engine allows you to create snapshots of your PostgreSQL databases running in Docker containers.

Requirements

The PostgreSQL Local engine has been tested with Postgres.app and should be compatible with any recent version of PostgreSQL installed on a host machine ( >= PostgreSQL 9.2 ) that includes pg_dump, pg_restore, and psql in the path.

Usage Notes

Specifying the PostgreSQL Local Engine

To use the PostgreSQL Local engine to create or load a database snapshot, use the default postgres:// scheme for the source or destination target url as needed. For example:

postgres://username:password@host/database?sslmode=[require | disable]

The postgres scheme is abbreviated as pgl in the CLI and DBSnapper cloud

Permissions

Permissions for various operations:

  • build
  • sanitize
  • load