1

When using Streaming Replication in Postgres 9.4, when a query makes the standby Postgres "start to count" the max_standby_streaming_delay, changes being made in the primary:

  1. Are dammed at the primary (not sent to standby) using the wal_keep_segments setting to limit that; OR
  2. Are sent to standby and stored locally (where?) at the standby for later processing?

Scenario 1 would lead to a bigger data loss in the event of a crash in the primary. On the other hand, the scenario 2 may lead to a filesystem being completely filled if the allowed dalay is too big.

asked Jul 17, 2018 at 19:48

1 Answer 1

0

They are stored in the replica's pg_xlog directory.

answered Jul 17, 2018 at 21:33

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.