Re: [GENERAL] Methods to quiesce PostgreSQL DB without configuring log archival

2016-11-23 Thread John R Pierce
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

Re: [GENERAL] Methods to quiesce PostgreSQL DB without configuring log archival

2016-11-23 Thread Kevin Grittner
On Wed, Nov 23, 2016 at 11:53 AM, Scott Mead wrote: > On Nov 22, 2016, at 01:23, 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? > > If your snap

Re: [GENERAL] Methods to quiesce PostgreSQL DB without configuring log archival

2016-11-23 Thread Scott Mead
> On Nov 22, 2016, at 01:23, MEERA wrote: > > Hi all, > > 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? If your snapshot solution is atomic, then you are *pr