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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
