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=#
Wednesday, November 23, 2022
PostgreSQL : How to verify archive mode is enabled or not
I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert .
Database Administration and Implementation. Provide technical guidance and work with global team.
Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible
Subscribe to:
Posts (Atom)