Skip to content

Instantly share code, notes, and snippets.

@jayuloy

jayuloy/psqlfix.txt

Created July 25, 2017 11:44
Show Gist options
  • Save jayuloy/e221a2f8547ebdfee7f0838a9ec3a2f2 to your computer and use it in GitHub Desktop.
Save jayuloy/e221a2f8547ebdfee7f0838a9ec3a2f2 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Mike Gunderloy created this gist Mar 19, 2011.
    20 changes: 20 additions & 0 deletions psqlfix.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,20 @@
    mike@rbci:~$ psql -U postgres
    psql (9.0.3)
    Type "help" for help.

    postgres=# update pg_database set datallowconn = TRUE where datname = 'template0';
    UPDATE 1
    postgres=# \c template0
    You are now connected to database "template0".
    template0=# update pg_database set datistemplate = FALSE where datname = 'template1';
    UPDATE 1
    template0=# drop database template1;
    DROP DATABASE
    template0=# create database template1 with template = template0 encoding = 'UTF8';
    CREATE DATABASE
    template0=# update pg_database set datistemplate = TRUE where datname = 'template1';
    UPDATE 1
    template0=# \c template1
    You are now connected to database "template1".
    template1=# update pg_database set datallowconn = FALSE where datname = 'template0';
    UPDATE 1