Re: Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc)

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Adrian Heath <adrian(dot)heath(at)tracktrans(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc)
Date: 2018-05-04 11:07:10
Message-ID: 6e9764f7-f6d1-0597-ecf7-c78d66d84007@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nikhil raj 2018-05-04 11:44:39 How to find the hits on the databases and tables in Postgres
Previous Message Adrian Heath 2018-05-04 10:41:50 Can we run pg_basebackup master is still working normally (selects, updates, deleted, etc)