On 11/18/16 6:17 AM, rajan wrote: > 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? Well, the point of the WAL is to preserve data integrity in case of crashes. So, no, that should normally not cause problems. > 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. It is written in smaller chunks and then archived or rotated when the 16 MB are full. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
