Re: WAL restoration is not happening completely

From: rajan <vgmonnet(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL restoration is not happening completely
Date: 2016-11-18 11:17:12
Message-ID: 1479467832483-5930928.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message rajan 2016-11-18 11:56:03 Re: Why are a lot of ROLLBACK queries in idle state
Previous Message Thomas Kellerer 2016-11-18 10:26:03 Re: Why are a lot of ROLLBACK queries in idle state