Re: hot standby in Postgresql 12 - Mailing list pgsql-admin

From Ankush Chawla
Subject Re: hot standby in Postgresql 12
Date
Msg-id CAOY8JhDE6Sh1Ljc4RWQh3BB7UPwzDvOPK03Px66dGjhi5PZ13A@mail.gmail.com
Whole thread Raw
In response to Re: hot standby in Postgresql 12  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: hot standby in Postgresql 12
List pgsql-admin
Ok, thanks. 
But what is the logic behind that ... does the database only comes up after a switch 

On Tue, Jan 19, 2021 at 9:18 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Monday, January 18, 2021, Ankush Chawla <ankushchawla03@gmail.com> wrote:
log files ;


2021-01-18 07:31:00.946 UTC   [21072]LOG:  database system was interrupted; last known up at 2021-01-18 07:30:07 UTC
cp: cannot stat '/u01/archive/00000004.history': No such file or directory
2021-01-18 07:31:00.963 UTC   [21072]LOG:  entering standby mode
2021-01-18 07:31:00.966 UTC   [21072]LOG:  restored log file "00000003.history" from archive
2021-01-18 07:31:00.981 UTC   [21072]LOG:  restored log file "000000030000000000000034" from archive
2021-01-18 07:31:01.029 UTC   [21072]LOG:  redo starts at 0/34000028
2021-01-18 07:31:01.030 UTC   [21072]LOG:  consistent recovery state reached at 0/34000138
cp: cannot stat '/u01/archive/000000030000000000000035': No such file or directory
2021-01-18 07:31:01.043 UTC   [21079]LOG:  started streaming WAL from primary at 0/35000000 on timeline 3

And now the standby is waiting for the next wal file to be archived by the primary.  You should probably set archive_timeout to a non-zero value since the primary doesn’t seem very busy (though you also still need to do at least one write, empty wal files don’t get rotated out and archived.)

David J.



--
Best Regards,
Ankush Chawla

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: hot standby in Postgresql 12
Next
From: "David G. Johnston"
Date:
Subject: Re: hot standby in Postgresql 12