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

From: Adrian Heath <adrian(dot)heath(at)tracktrans(dot)com>
To: 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:45:00
Message-ID: ff66f500-3a3f-27c3-d466-dbb958b578a8@tracktrans.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/05/18 12:07, Peter Eisentraut wrote:
> 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.
>
Thank you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-05-04 13:21:00 Re: How to find the hits on the databases and tables in Postgres
Previous Message nikhil raj 2018-05-04 11:44:39 How to find the hits on the databases and tables in Postgres