From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | streaming replication question |
Date: | 2010-10-02 16:02:44 |
Message-ID: | AANLkTimcbivpwM3YrAW3N0Wqmft8mhACt6Y-Gib9JcL5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Dear List,
Firstly thanks to the postgresql global development team for releasing
postgresql
with such a great enterprise feature of SR & HS.
As an enduser i setup SR based on
http://wiki.postgresql.org/wiki/Streaming_Replication
The master & standby are both powerful machines and are on same gigabit
switch.
Things worked as expected I updated 1000's of records in single txn and saw
them
appearing on the standby instantly.
Then i wanted to see the impact of shutting down the standby momentarily .
This apparently
failed with following messages in standby logs:
DETAIL: last completed transaction was at log time 2010-10-02
20:57:26.17677+05:30
LOG: restartpoint starting: time
LOG: received smart shutdown request
FATAL: terminating walreceiver process due to administrator command
LOG: restartpoint complete: wrote 1568 buffers (0.3%); write=146.237 s,
sync=0.251 s, total=146.489 s
LOG: recovery restart point at 25/EA87BA18
DETAIL: last completed transaction was at log time 2010-10-02
21:02:21.89303+05:30
LOG: shutting down <--- - - - - - - - - - - - - -- - - shutdown command
issued here
LOG: database system is shut down
LOG: database system was shut down in recovery at 2010-10-02 21:02:22 IST
<---------------- first attempt to start was made
LOG: entering standby mode
LOG: restored log file "0000000100000025000000EA" from archive
LOG: redo starts at 25/EA87BA18
FATAL: too many KnownAssignedXids
CONTEXT: xlog redo insert: rel 1663/16399/303892827; tid 1503/119
LOG: startup process (PID 20527) exited with exit code 1
LOG: terminating any other active server processes
LOG: database system was interrupted while in recovery at log time
2010-10-02 20:57:12 IST <--------------- second attempt was made.
HINT: If this has occurred more than once some data might be corrupted and
you might need to choose an earlier recovery target.
LOG: entering standby mode
LOG: restored log file "0000000100000025000000EA" from archive
LOG: redo starts at 25/EA87BA18
FATAL: too many KnownAssignedXids
CONTEXT: xlog redo insert: rel 1663/16399/303892827; tid 1503/119
LOG: startup process (PID 20693) exited with exit code 1
LOG: terminating any other active server processes
I confess that i have not RT(Fine)M yet .
Regds
Rajesh Kumar Mallah.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus Moor | 2010-10-02 20:30:39 | 9.0 SSL renegotiation failure restoring data |
Previous Message | Christian Ullrich | 2010-10-02 14:47:06 | Re: Group By Question |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2010-10-02 17:01:45 | configure gaps |
Previous Message | Andrew Dunstan | 2010-10-02 15:09:32 | Re: missing tags |