Snapshot backups
Hey All,
This is a message to confirm my thoughts / validate a possible approach.
In a situation where PGDATA and {XLOG, ARCHIVELOG} are on different SAN/NAS volumes and a backup is to be initiated do pg_start_backup and pg_stop_backup need to be used?
I am using snapshots of each volume for backup.
My thinking is that they are not needed (although I realise it is good practice).
As far as I can tell all they are doing is something like:
pg_start_backup:
- create backup label
- trigger checkpoint
pg_stop_backup
- remove backup label file
- creates backup history file
- trigger log switch
There is nothing in here that is *required* from a backup point of view. Am I missing anything?
James Sewell
Solutions Architect
_____________________________________
The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.
Вложения
В списке pgsql-general по дате отправления: