...
A PostgreSQL Ephemeral database copy is created using the following command
| Code Block |
|---|
pg_dump -h <hostname> -p <port> -U <liquibase_user> -F c -n <schema(s)> -n <tracking_schema> --schema-only -f <backup_dir> <db_name>
CREATE DATABASE <db_name>_eph
pg_restore -h <hostname> -p <port> -U <liquibase_user> -F c -n <schema(s)> -n <tracking_schema> --schema-only -d <db_name>_eph <backup_dir> |
Pre-requisites
Requires Liquibase Enterprise 8.8 and higher
The Liquibase user for the first database in the pipeline must have permission to create databases.
...