Re: WAL restoration is not happening completely - Mailing list pgsql-admin

From rajan
Subject Re: WAL restoration is not happening completely
Date
Msg-id 1479467832483-5930928.post@n3.nabble.com
Whole thread Raw
In response to Re: WAL restoration is not happening completely  (Andres Freund <andres@anarazel.de>)
Responses Re: WAL restoration is not happening completely
List pgsql-admin
thanks Ian, Peter and Andres for the replying.

One thing I missed to update is that the Source(master) machine I was
running is switched off and on everyday. It may have caused any disruption
in the WAL files?

And one more question, The WAL files are created as 16MB segments, that is
obvious. But I do not know when the file is completely written. Is it like,
a file is created and then written till 16MB or 16MB data segment is
directly written at once.

These questions may be stupid but I thought it will help understand the
process.



-----
--
Thanks,
Rajan.
--
View this message in context:
http://postgresql.nabble.com/WAL-restoration-is-not-happening-completely-tp5930204p5930928.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Why are a lot of ROLLBACK queries in idle state
Next
From: rajan
Date:
Subject: Re: Why are a lot of ROLLBACK queries in idle state