pg_receivewal unable to connect to promoted standby

Hi, I'm trying to have a setup where there is a primary, standby and pg_receivewal (which acts as a server that maintains the entire WAL). Quorum is any one of standby and pg_receivewal. In case of primary crash, when I promote standby (timeline switch from 5 to 6) and restart pg_receivewal to con

pg_page_repair: a tool/extension to repair corrupted pages in postgres with streaming/physical replication

Hi, Problem: Today when a data page is corrupted in the primary postgres with physical replication (sync or async standbys), there seems to be no way to repair it easily and we rely on PITR to recreate the postgres server or drop the corrupted table (of course this is not an option for important c

Re: pg_walinspect - a new extension to get raw WAL data and WAL stats

Hi Bharath, First look at the patch, bear with me if any of the following comments are repeated. 1. With pg_get_wal_record(lsn), say a WAL record start, end lsn range contains the specified LSN, wouldn't it be more meaningful to show the corresponding WAL record. For example, upon providing '0/173

[Proposal] pg_rewind integration into core

Hi, It's possible to have a good number of standbys (in the context of async streaming replication) as part of the client architecture. Rather than asking the client to look into the intricacies of comparing the LSN of each standby with that of primary and performing the pg_rewind, isn't it a good

pg_rewind enhancements

Hi, While using pg_rewind, I found that it is a bit difficult to use pg_rewind as it seems to copy even the configuration files and also remove some of the files created on the old primary which may not be present on the new primary. Similarly it copies files under the data directory of the new pr

Isolation levels on primary and standby

Hello All, It looks like we could have different isolation levels on primary and standby servers in the context of replication. If the primary crashes and a standby server is made as primary, there could be change in query results because of isolation levels. Is that expected? Thanks, RKN

Query regarding replication slots

Hi All, I have a very basic question related to replication slots. Why should the master/primary server maintain the replication slot info like lsn corresponding to each standby server etc. Instead, why can't each standby server send the lsn that it needs, and master/primary server maintain the mi