'[GENERAL] pg_basebackup on standby node failed'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] pg_basebackup on standby node failed
From:       Ying He <yinghe0101 () yahoo ! com>
Date:       2014-01-31 22:07:27
Message-ID: 1391206047.8523.YahooMailNeo () web164604 ! mail ! gq1 ! yahoo ! com
[Download RAW message or body]

hi, All,

I intend to do a basebackup on a hot standby node. I followed  the instructions on \
http://www.postgresql.org/docs/9.2/static/app-pgbasebackup.html to turn \
full_page_writes on at master and other settings on standby.

When I try to select pg_start_backup('backuplabel'); on the standby instance, it give \
                me the following:
ERROR:  recovery is in progress
HINT:  WAL control functions cannot be executed during recovery.


I tried select  pg_xlog_replay_pause(); before the select \
pg_start_backup('backuplabel'); but that does not help.

Also why select pg_is_in_recovery(); always returns true when select  \
pg_is_xlog_replay_paused(); is true? I thought when I do select  \
pg_xlog_replay_pause(); the standby should not be in recovery

Please help if you know anything about this. Thank you.

best,
Ying


[Attachment #3 (text/html)]

<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, \
Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div>hi, \
All,</div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; \
font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; \
background-color: transparent; font-style: normal;">I intend to do a basebackup on a \
hot standby node. I followed&nbsp; the instructions on \
http://www.postgresql.org/docs/9.2/static/app-pgbasebackup.html to turn \
full_page_writes on at master and other settings on standby.</div><div style="color: \
rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica \
Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; \
font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; \
font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; \
background-color: transparent;  font-style: normal;">When I try to select \
pg_start_backup('backuplabel'); on the standby instance, it give me the \
following:</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: \
HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; \
background-color: transparent; font-style: normal;">ERROR:&nbsp; recovery is in \
progress<br>HINT:&nbsp; WAL control functions cannot be executed during \
recovery.<br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: \
HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; \
background-color: transparent; font-style: normal;"><br></div><div style="color: \
rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica \
Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; \
font-style: normal;">I tried select&nbsp; pg_xlog_replay_pause(); before the select \
pg_start_backup('backuplabel'); but that does not help.</div><div style="color: \
rgb(0,  0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica \
Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; \
font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; \
font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; \
background-color: transparent; font-style: normal;">Also why select \
pg_is_in_recovery(); always returns true when select&nbsp; \
pg_is_xlog_replay_paused(); is true? I thought when I do select&nbsp; \
pg_xlog_replay_pause(); the standby should not be in recovery</div><div style="color: \
rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica \
Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; \
font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; \
font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; \
background-color: transparent; font-style: normal;">Please help if  you know anything \
about this. Thank you.</div><div style="color: rgb(0, 0, 0); font-size: 16px; \
font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; \
background-color: transparent; font-style: normal;"><br></div><div style="color: \
rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica \
Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; \
font-style: normal;">best,</div><div style="color: rgb(0, 0, 0); font-size: 16px; \
font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; \
background-color: transparent; font-style: \
normal;">Ying<br></div></div></body></html>



[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic