Skip to content

Instantly share code, notes, and snippets.

@hoangvanthien

hoangvanthien/clone-postgresql-database.md

Created June 21, 2022 03:14
Show Gist options
  • Save hoangvanthien/e958294397792afdfcbb983192d519c2 to your computer and use it in GitHub Desktop.
Save hoangvanthien/e958294397792afdfcbb983192d519c2 to your computer and use it in GitHub Desktop.
Download ZIP
Clone Postgresql database
Raw
clone-postgresql-database.md

Terminate any connections to sourceDB

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity 
WHERE pg_stat_activity.datname = 'sourceDB' AND pid <> pg_backend_pid();

Then clone sourceDB into newDB

CREATE DATABASE newdb WITH TEMPLATE sourceDB OWNER dbuser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment