一、数据库常用命令
1、查看数据库版本
highgo=# select kernel_version();kernel_version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.11 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17), 64-bit
(1 row)
highgo=# select version();
version
------------------------------------
HighGo Database 3.1.4 Linux 64-bit
(1 row)
2、查看数据库启动时间
highgo=# select pg_postmaster_start_time();
pg_postmaster_start_time
-------------------------------
2017-07-19 08:50:48.399154+08
(1 row)
3、查看最后load配置文件的时间
highgo=# select pg_conf_load_time();
pg_conf_load_time
-------------------------------
2017-07-19 08:50:48.297432+08
(1 row)
使用pg_ctl reload改变配置的装载时间,如下:
[highgo@sourcedb ~]$ pg_ctl reload
server signaled
[highgo@sourcedb ~]$ psql
psql (3.1.4)
Type "help" for help.
highgo=# select pg_conf_load_time();
pg_conf_load_time
-------------------------------
2017-07-19 13:52:4