akp geek wrote:
One small doubt I have is , do we have to keep the backup_label on
the standby, I deleted it before I start the restore process , it
still worked .. Just curious
The backup label is strictly for you to read, to help make sure you got
all of the archived segments necessary for t
Thanks a lot Richard. The culprit in my case is the restore command , I
modified it as follows per your instructions , it is fine now
restore_command = 'pg_standby -d -s 5 -t /tmp/pg_standby.trigger.5432
/opt/postgres/archive %f %p %r 2>>/tmp/standby.log'
One small doubt I have is , do we have
akp geek wrote:
> Hi experts -
>
> I am running into issue with pg_standby. May be my
> understanding is not correct. Please help. here is what I did .
>
>
>1. I made changes in the postgresql.conf ( archive_mode = on
>,archive_command = 'cp -i %p /opt/postgres/archi
Hi experts -
I am running into issue with pg_standby. May be my
understanding is not correct. Please help. here is what I did .
1. I made changes in the postgresql.conf ( archive_mode = on
,archive_command = 'cp -i %p /opt/postgres/archive/%f' , archive_timeout =
60
