PG重建临时库

xiaoxiao2021-02-28  121

highgo=# drop database template1; ERROR: 42809: cannot drop a template database highgo=# UPDATE pg_database SET datistemplate='false' WHERE datname='template1'; UPDATE 1 highgo=# drop database template1; DROP DATABASE highgo=# create database template1 template template0; CREATE DATABASE highgo=# UPDATE pg_database SET datistemplate='true' WHERE datname='template1'; UPDATE 1
转载请注明原文地址: https://www.6miu.com/read-27217.html

最新回复(0)