Wednesday, November 23, 2022

PostgreSQL : How to verify archive mode is enabled or not

 How to verify archive mode is enabled or not



Login to PostgreSQL database with super privilege 


postgres=#

postgres=# show archive_mode;

 archive_mode

--------------

 off

(1 row)


postgres=#

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to verify whether TIMED_STATISTICS changed between the oracle AWR database snapshots ?

To verify whether TIMED_STATISTICS changed between the snapshots used in your AWR Diff report, you can check the historical parameter value...