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=#

what is catcon.pl (Catalog Container Script) and why very useful for Oracle Multitenant Database ?

  catcon.pl (Catalog Container Script) is an Oracle utility introduced with the Multitenant Architecture (CDB/PDB) to execute SQL scripts ...