pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
streaming replication corruption Q's 2+ messages / 2 participants [nested] [flat]
* streaming replication corruption Q's @ 2017-10-04 19:01 ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca> 2017-10-05 07:07 ` Re: streaming replication corruption Q's Laurenz Albe <laurenz.albe@cybertec.at> 0 siblings, 1 reply; 2+ messages in thread From: ghiureai @ 2017-10-04 19:01 UTC (permalink / raw) To: pgsql-admin Hi List, I'm reading PG 10 streaming replication manual, I would like to learn from your expertise if this type of replication will copy a bad segment/bit corrupt from master to slave host , will this possible to happened ? What are the most common issues you seeing when running streaming replication, any files/bits corruption ( from my understanding logical replication will replicate data corruption)where do you have to pay attention when setting up a new system like this , Thank you Isabella -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: streaming replication corruption Q's 2017-10-04 19:01 streaming replication corruption Q's ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca> @ 2017-10-05 07:07 ` Laurenz Albe <laurenz.albe@cybertec.at> 0 siblings, 0 replies; 2+ messages in thread From: Laurenz Albe @ 2017-10-05 07:07 UTC (permalink / raw) To: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>; pgsql-admin ghiureai wrote: > I'm reading PG 10 streaming replication manual, I would like to learn > from your expertise if this type of replication will copy a bad > segment/bit corrupt from master to slave host , will this possible to > happened ? Streaming replication happens on a physical level, so it does not pay attention to logical consistency. If the primary is suffering from data corruption, every data modification containing that data corruption will be replicated. > What are the most common issues you seeing when running streaming > replication, any files/bits corruption ( from my understanding > logical replication will replicate data corruption)where do you have to > pay attention when setting up a new system like this , That question is too general... Make sure that you are running the same operating system version on (ideally) the same hardware on all machines. Either set wal_keep_segments high enough or (more cumbersome, but more reliable) configure WAL shipping as a fallback when the standby has a longer down time. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-10-05 07:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2017-10-04 19:01 streaming replication corruption Q's ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca> 2017-10-05 07:07 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox