How vacuum template0, vacuumtemplate0
[Pg @ h1 ~] $ Vacuumdb -- freeze template0vacuumdb: cocould not connect to database template0: FATAL: database "template0" is not currently accepting connections [pg @ h1 ~] $ Psql template0psql: FATAL: database "template0" is not currently accepting connections [pg @ h1 ~] $ PGOPTIONS = '-c gp_session_role = utility' psql template1psql (8.2.15) Type "help" for help. template1 = # set allow_system_table_mod = 'dml'; SETtemplate1 = # update pg_database set datallowconn = 't'where datname = 'template0 '; UPDATE 1template1 = # \ c template0You are now connected to database "template0" as user "pg ". template0 = # vacuum freeze; VACUUMtemplate0 = # \ q [pg @ h1 ~] $ PGOPTIONS = '-c gp_session_role = utility' psql template1psql (8.2.15) Type "help" for help. template1 = # set allow_system_table_mod = 'dml'; SETtemplate1 = # update pg_database set datallowconn = 'F' where datname = 'template0'; UPDATE 1
-EOF-