CODEWITHSUNDEEP
postgresqldatabase-replicationpostgresql-9.3
Rockyboy_ruby
Rockyboy_ruby

Reputation: 233

How to introduce delay in POSTGRESQL 9.3 replication?

I have master slave replication setup. How I can force some delay in replication ?

Is there a setting that I can use ?

Thanks !

Upvotes: 0

Views: 1120

Answers (1)

Craig Ringer
Craig Ringer

Reputation: 324265

Not in 9.3.

In 9.4 you can use min_recovery_apply_delay. See this blog post.

In 9.3, if you have WAL-archive based replication (no streaming) you could archive the WAL to one location, and only move it to a location readable by the standby after a delay. You can't do it with streaming in 9.3.

Upvotes: 1

Related Questions