DBA Hub

📋Steps in this guide1/1

Find the last pg config reload time

-- Last pg config reload time

postgresql configurationintermediate
by PostgreSQL
11 views
1

Find the last pg config reload time

-- Last pg config reload time -- Reload again and see whether reload time changed or not

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
postgres=#
select pg_conf_load_time() ;
pg_conf_load_time
----------------------------------
2020-07-06 13:20:18.048689+05:30
(1 row)
postgres=#
select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)
postgres=#
select pg_conf_load_time() ;
pg_conf_load_time
----------------------------------
2020-07-06 17:46:59.958056+05:30
(1 row)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!