When a postgresql standby gets out of sync and the replication lag is relatively big, the usual solution is to clone the primary database again, to avoid the slow proess of re-applying all archived WALs that are lagging. However, a complete clone of a large database could be long. As I wondered the other time how I could do the same technique as for Oracle databases: identify the current SCN on the physical.. Read More