Hello Frineds, i wannt to get postgresl cluster file system level backup. My scenario is like this:
*1.Step ) Pre Synchronization* rsync -avHK --delete /var/lib/pgsql/ /backup/pgsql/ *2. Step.) Stop Service for consistent Backup * systemctl stop postgresql-9.5 *3. Step.) Make File System Level Backup* rsync -avHK --delete /var/lib/pgsql/ /backup/pgsql/ *4.Step.) Start Service Again* systemctl start postgresql-9.5 *In This Scenario * *I ask to you , can we lock all databases for write , delete and update query during the backup Instead of stopping the service. ??*