PG基础巡检

表空间 数据库 模式 表 用户
\db+ \l+ \dn+ \dt+ \du+

--用户
select * from pg_user
select * from pg_shadow


select * from pg_database

--配置文件
select name,setting from pg_settings where name like '%config_file%'
select * from pg_file_settings

--字符集
select name,setting,category,short_desc from pg_settings ps where ps.name like 'lc%' or ps.name like '%coding%'order by name;

postgres=# select * from pg_ls_waldir();
           name           |   size   |      modification      
--------------------------+----------+------------------------
 000000010000000000000011 | 16777216 | 2023-04-25 09:44:45+08
 000000010000000000000012 | 16777216 | 2023-04-24 10:45:58+08
 000000010000000000000013 | 16777216 | 2023-04-24 10:45:58+08
 000000010000000000000014 | 16777216 | 2023-04-24 10:45:58+08
 000000010000000000000015 | 16777216 | 2023-04-24 10:45:59+08
 000000010000000000000016 | 16777216 | 2023-04-24 10:50:48+08
 000000010000000000000017 | 16777216 | 2023-04-24 10:50:49+08
 000000010000000000000018 | 16777216 | 2023-04-24 10:50:50+08
 000000010000000000000019 | 16777216 | 2023-04-24 10:50:52+08
 00000001000000000000001A | 16777216 | 2023-04-24 10:50:55+08
(10 rows)