• How vacuum template0



    [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-
  • 相关阅读:
    JAVA的反射理解
    网络编程-小结
    JAVA多线程的总结
    Mysql基本语句的总结
    IO流
    JAVA集合介绍
    时间复杂度
    JAVA面向对象-多态的理解
    求A的B次方
    最大公约数
  • 原文地址:https://www.cnblogs.com/gavanwanggw/p/6722329.html
Copyright © 2020-2023  润新知