On 11/21/2016 10:23 PM, MEERA wrote:
If archive_mode is not configured, and i use snapshot solution for backup of the server, how can i ensure data consistency? Is there a way to quiesce all the connections to DB? select pg_startbackup(); before taking the file system copy or snapshot, and select pg_stopbackup(); when you're done.
-- john r pierce, recycling bits in santa cruz |