Re: Pgbasebackup help

On 12/2/2015 9:59 PM, Yelai, Ramkumar IN BLR STS wrote:
>   I can't shutdown the database during the backup and unable to use file system copy of data folder as it creates
inconsistency

If you invoke pg_start_backup()  before the copy, and pg_stop_backup()
after the copy, then a file system copy is consistent.

see
http://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-ADMIN-BACKUP
for the explanation of those functions.


--
john r pierce, recycling bits in santa cruz