| From: | Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> |
|---|---|
| To: | rajesh singarapu <rajesh(dot)rs0541(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Postgres Replication from windows to linux |
| Date: | 2022-01-12 13:38:29 |
| Message-ID: | d793f13e-c911-7aae-5875-064bdf5855d7@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 10.01.22 19:56, rajesh singarapu wrote:
> I am trying to migrate my postgres to linux, as we are moving away from
> windows.
> I am trying both dump/restore and logical decoding, but people are not
> happy with performance.
> Is there a way/tooling I can use around WAL shipping/physical
> replication here ?
Cross-platform physical replication is always risky. It might work, but
there is no easy way to find out whether everything is ok afterwards.
Aside from the issue of possible storage format differences, I would
also be worried about locale differences affecting text sort order.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | houzj.fnst@fujitsu.com | 2022-01-12 13:48:55 | RE: row filtering for logical replication |
| Previous Message | Finnerty, Jim | 2022-01-12 13:32:16 | Re: Add 64-bit XIDs into PostgreSQL 15 |