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 Adrian Heath
Subject Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)
Date
Msg-id ff66f500-3a3f-27c3-d466-dbb958b578a8@tracktrans.com
Whole thread Raw
In response to Re: Can we run pg_basebackup master is still working normally(selects, updates, deleted, etc)  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: nikhil raj
Date:
Subject: How to find the hits on the databases and tables in Postgres
Next
From: Adrian Klaver
Date:
Subject: Re: How to find the hits on the databases and tables in Postgres