Restart of Master Postgres DB with unconsumed Wal files
Posted
by Douglas Sellers
on Stack Overflow
See other posts from Stack Overflow
or by Douglas Sellers
Published on 2010-04-27T23:30:24Z
Indexed on
2010/04/27
23:33 UTC
Read the original article
Hit count: 308
postgresql
We have a situation where walmanager is being used to ship wal files between a master and a slave Postgres database. The slave machine has failed and has had to have been rebuilt. This has caused a lot of unconsumed wal files to build up on the master.
If a reboot is issued to the Postgres master, and there are 24 hours worth of unconsumed wal files hanging around, will the master be effected at all or will it start clean?
© Stack Overflow or respective owner