Unanswered: WAL Archiving required for synchronous Replication?
Have searched around but didn't find anything so I will try to get an answer here :-)
A setup of two Windows Servers having PostgreSQL 9.1.2 installed and synchronous replication setup between them. The PostgreSQL initial setup was done with WAL file archiving.
What I understood so far is, archive files are not needed any longer since synchronous replication can be used. It was rather the case with streaming replication and other replication methods. Now there is no lack between the storage on the master and the slave as the master waits for the slave to commit before he commits the query himself.
Can anyone of you please put some light on this?
And if archiving is mandatory in this setup scenario, could anyone help me out with a pg_archivecleanup command or script which will work on Windows, please?