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