Pg_basebackup can realize remote hot backup database? Incremental backup can use it?

CodePudding user response:

Pg_basebackup remotely hot backup, add parameters - h database address
Its approximate completely hot backup, all physical database copy down, not in the database and the incremental backup
There may be inconsistent data backup problem,
So cannot be used alone as a recovery, must cooperate with WAL archive records for recovery

CodePudding user response:

Are you going to do a hot standby?
http://postgres.cn/docs/11/warm-standby.html#STANDBY-SERVER-SETUP

CodePudding user response:

Is a local disk is not enough, can use HDFS loaded stored on a remote server to your local database,

CodePudding user response:

Is to want to put the data in another place, afraid of the database,