Re: Methods to quiesce PostgreSQL DB without configuring log archival

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