Skip to content

Instantly share code, notes, and snippets.

@jms

jms/restore.sql

Forked from juike/restore.sql
Created June 5, 2018 20:47
Show Gist options
  • Save jms/9c2ae800e036b57c93e5adafb5de9554 to your computer and use it in GitHub Desktop.
Save jms/9c2ae800e036b57c93e5adafb5de9554 to your computer and use it in GitHub Desktop.
Download ZIP
Restoring a 'template1' database in PostgreSQL. (https://wiki.postgresql.org/wiki/Adventures_in_PostgreSQL,_Episode_1)
Raw
restore.sql
UPDATE pg_database SET datallowconn = TRUE WHERE datname = 'template0';
\c template0
UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
DROP DATABASE template1;
CREATE DATABASE template1 WITH TEMPLATE = 'template0';
\c template1
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
UPDATE pg_database SET datallowconn = FALSE WHERE datname = 'template0';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment