Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc) - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)
Date
Msg-id 6e9764f7-f6d1-0597-ecf7-c78d66d84007@2ndquadrant.com
Whole thread Raw
In response to Can we run pg_basebackup master is still working normally (selects,updates, deleted, etc)  (Adrian Heath <adrian.heath@tracktrans.com>)
Responses Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)  (Adrian Heath <adrian.heath@tracktrans.com>)
List pgsql-general
Tree view 
On 5/4/18 06:41, Adrian Heath wrote:
> The system is used 24/7. Can we run pg_basebackup while the master is 
> still receiving updates without worrying about physical file corruptions 
> in the generated archive file?

Yes, as long as you follow the instructions about saving the WAL
generated during the backup and replaying it on the newly created standby.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Adrian Heath
Date:
Subject: Can we run pg_basebackup master is still working normally (selects,updates, deleted, etc)
Next
From: nikhil raj
Date:
Subject: How to find the hits on the databases and tables in Postgres