Friday, 24 June 2022

POSTGRESQL BACKUP & RECOVERY

 POSTGRESQL BACKUP AND RECOVERY

POSTGRESQL BACKUP AND RECOVERY



Hot Backup:-
Note:-
1. Database is must online(No Shutdown).
2.Archive mode must enabled
     archive_command = 'cp %p /archive/%f'
     archive_mode =on
     wal_level=archive 
Step1:-
Go to database Level to find databse id ,its helpfull for easily find os level folders
 























- No comments:
Subscribe to: Posts (Atom)

PostgreSQL Health Check - Performance Audit and Recommendations

   PostgreSQL Server Capacity Planning and Optimization: Conduct a thorough assessment of current and projected workload demands on the data...

  • Job scheduler for PostgreSQL "pg_cron"
    What is pg_cron   : -   pg_cron is a simple cron-based job scheduler for   PostgreSQL (9.5 or higher)   that runs inside the database as an ...
  • PostgreSQL - Architecture
    When you start PostgreSQL`s instance (via pg_ctl start) the main process of the databases is started. In the past versions it was known as...
  • POSTGRESQL DATABASE MAINTENANCE
      Routine backup of daily database maintenance work , regular “clean up” database, periodic log file management check_postgres can be used t...