Howvacuumtemplate0
程序员文章站
2022-05-24 10:02:11
...
[pg@h1 ~]$ vacuumdb --freeze template0vacuumdb: could not connect to database template0: FATAL: database template0 is not currently accepting connections[pg@h1 ~]$ psql template0psql: FATAL: database template0 is not currently accepting co
[pg@h1 ~]$ vacuumdb --freeze template0 vacuumdb: could not connect to database template0: FATAL: database "template0" is not currently accepting connections [pg@h1 ~]$ psql template0 psql: FATAL: database "template0" is not currently accepting connections [pg@h1 ~]$ PGOPTIONS='-c gp_session_role=utility' psql template1 psql (8.2.15) Type "help" for help. template1=# set allow_system_table_mods='DML'; SET template1=# update pg_database set datallowconn='t' where datname='template0'; UPDATE 1 template1=# \c template0 You are now connected to database "template0" as user "pg". template0=# vacuum freeze ; VACUUM template0=# \q [pg@h1 ~]$ PGOPTIONS='-c gp_session_role=utility' psql template1 psql (8.2.15) Type "help" for help. template1=# set allow_system_table_mods='DML'; SET template1=# update pg_database set datallowconn='f' where datname='template0'; UPDATE 1
-EOF-
上一篇: php获取分类下的所有子类方法
下一篇: php多文件上传功能实现原理及代码