On Tue, 2007-09-25 at 14:14 -0300, Cesar Otero wrote:
> I think that after restarting standby db the first log should be last
> log applied + 1
That isn't how it works, for performance reasons.
We don't make a restartpoint after each file, we do this on the first
usable checkpoint WAL record tha
I mean before shutdown the last log applied was
0001001800A5 and after restart pg try to apply from wal
00010018009D.
The 00010018009D file is the first wal created in the hot
backup process.
I think that after restarting standby db the first log should be last
On Tue, 2007-09-25 at 12:41 -0300, Cesar Otero wrote:
> Then shutdown standby
>
> ##
> WAL file not present yet. Checking for trigger file...2007-09-25
> 12:31:47 ARTLOG: received fast shutdown request
> 2007-09-25 12:31:47 ARTFATAL: could not restore
Hi all:
I am testing warm standby databases.
I start standby database
##
2007-09-25 12:21:45 ARTLOG: database system was interrupted at
2007-09-25 12:16:22 ART
2007-09-25 12:21:45 ARTLOG: starting archive recovery
2007-09-25 12:21:45 ARTLOG: restor