cmolong的博客

备份当前服务器数据库pg_dump -U gpadmin 待备份数据库名称 > 备份数据库存放路径/备份数据库文件.dmp例如：备份数据库为db_test,路径为home/gpadmin，将数据库备份为dbtest文件名pg_dump -U gpadmin db_test > /home/gpadmin/dbtest.dmp还原将dbtest还原到待恢复数据库中psq...

查看数据库创建、修改信息SELECT (pg_stat_file('base/'||oid ||'/PG_VERSION')).modification, datname FROM pg_database;SELECT (pg_stat_file(‘base/’||oid ||’/PG_VERSION’)).modification, datname FROM pg_database;或者...

#查询所有数据库大小select datname AS db_name, pg_size_pretty(pg_database_size(datname)) as db_sizefrom pg_database order by pg_database_size(datname) desc;