Hello David,
Thank you so much for quick response.
I have couple of questions on recoveries.
1. my postgres did not recovered/read all the wal logs that are existed in wal location? is it some thing wrong i am doing ?
content of my recovery file command
cat recovery.conf
restore_command = 'cp /pgdata/archive/5444/%f %p'
2. what is the best way to instruct postgresql to read and apply all the logs are presented on wal location ?
please advise
On Mon, Apr 22, 2019 at 4:20 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Monday, April 22, 2019, Pavan Kumar <pavan.dba27@xxxxxxxxx> wrote:lost of latest wal file/log will give some data loss, need to find a way to have redundant copy on latest wall logfileThis is indeed the defined behavior for a cold storage backup system relying on wal shipping.If you want something better at maintaining recency you need to setup some kind of hot/live standby sever where all activity is immediately sent to and (more or less) applied to a second already running system. Though logical replication techniques on a current release may provide additional options.David J.
Regards,
#! Pavan Kumar
-----------------------------------------------
Sr. Database Administrator..!
NEXT GENERATION PROFESSIONALS, LLC
Cell # 267-799-3182 # pavan.dba27 (Gtalk)
#! Pavan Kumar
-----------------------------------------------
Sr. Database Administrator..!
NEXT GENERATION PROFESSIONALS, LLC
Cell # 267-799-3182 # pavan.dba27 (Gtalk)
India # 9000459083
Take Risks; if you win, you will be very happy. If you lose you will be Wise
