瀚高数据库（HGDB 3.1.4）常用管理命令

一、数据库常用命令

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