Posts

Showing posts from June, 2022

POSTGRESQL BACKUP & RECOVERY

Image
  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