pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication Question
2+ messages / 2 participants
[nested] [flat]
* Replication Question
@ 2020-07-16 21:10 Murthy Nunna <mnunna@fnal.gov>
2020-07-16 22:01 ` Re: Replication Question Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Murthy Nunna @ 2020-07-16 21:10 UTC (permalink / raw)
To: pgsql-admin
Folks:
I have a question about replication... Can I replicate to a server running different version of Linux OS (e.g Primary on RHEL 7 and stand-by on RHEL 6.1). Assume same postgres version on primary and stand-by, say version 9.5 or above.
I am interested in both streaming and WAL based replication.
Thanks for your attention.
Regards,
Murthy
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Replication Question
2020-07-16 21:10 Replication Question Murthy Nunna <mnunna@fnal.gov>
@ 2020-07-16 22:01 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2020-07-16 22:01 UTC (permalink / raw)
To: Murthy Nunna <mnunna@fnal.gov>; +Cc: pgsql-admin
Murthy Nunna <mnunna@fnal.gov> writes:
> I have a question about replication... Can I replicate to a server running different version of Linux OS (e.g Primary on RHEL 7 and stand-by on RHEL 6.1).
It's a little risky because of the possibility that the different OS
versions have different behavior for the "same" LC_COLLATE setting,
leading to different sort orders for text columns, which would make
indexes on text columns incorrect in the standby's worldview.
If you are only using "C" collation, or if you check that the collation(s)
you use behave the same on both platforms, it should be OK.
Also note that the hardware architecture had better be the same, eg
no 32-bit-to-64-bit cases. But Postgres can detect that type of problem
for itself, generally speaking. I emphasize collation hazards because
we lack any reliable detection for collation mismatch.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-07-16 22:01 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-07-16 21:10 Replication Question Murthy Nunna <mnunna@fnal.gov>
2020-07-16 22:01 ` Tom Lane <tgl@sss.pgh.pa.us>
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