Re: Methods to quiesce PostgreSQL DB without configuring log archival - Mailing list pgsql-general

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