Does logical replication supports cross platform servers?
Hi All,
I am not able to find any docs suggesting that PostgreSQL logical
replication supports
cross platform servers (windows --> Linux or vice-versa).
When I tried with simple basic commands and it worked and also some of the
other members are also suggesting to use logical replication for the above
scenarios in [1]https://stackoverflow.com/questions/46603257/can-we-replicate-postgres-data-between-two-os/46603426#46603426.
But I am unable find this support mentioning in the docs, Do we support? or
any problems? If it supports it is better to update the docs.
[1]: https://stackoverflow.com/questions/46603257/can-we-replicate-postgres-data-between-two-os/46603426#46603426
https://stackoverflow.com/questions/46603257/can-we-replicate-postgres-data-between-two-os/46603426#46603426
Regards,
Haribabu Kommi
Fujitsu Australia
On 12 June 2018 at 11:04, Haribabu Kommi <kommi.haribabu@gmail.com> wrote:
Hi All,
I am not able to find any docs suggesting that PostgreSQL logical
replication supports
cross platform servers (windows --> Linux or vice-versa).
It should. I don't think there's buildfarm coverage yet, though.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
On 06/11/2018 11:28 PM, Craig Ringer wrote:
On 12 June 2018 at 11:04, Haribabu Kommi <kommi.haribabu@gmail.com
<mailto:kommi.haribabu@gmail.com>> wrote:Hi All,
I am not able to find any docs suggesting that PostgreSQL logical
replication supports
cross platform servers (windows --> Linux or vice-versa).It should. I don't think there's buildfarm coverage yet, though.
Designing something like that would be more than interesting. We'd need
two or more co-operating animals, a concept that's currently quite
foreign to the buildfarm. I'm not saying it can't be done, but it would
be a substantial piece of work. Probably the place to start would be the
save-bin feature discussed elsewhere for things like cross-version
pg_dump/pg_restore checking. We already do that for cross-version
pg_upgrade testing, so it would need to be generalized.
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On Tue, Jun 12, 2018 at 1:29 PM Craig Ringer <craig@2ndquadrant.com> wrote:
On 12 June 2018 at 11:04, Haribabu Kommi <kommi.haribabu@gmail.com> wrote:
Hi All,
I am not able to find any docs suggesting that PostgreSQL logical
replication supports
cross platform servers (windows --> Linux or vice-versa).It should. I don't think there's buildfarm coverage yet, though.
Thanks for the confirmation.
This is a good use case that must be explicitly mentioned in the docs.
How about the attached patch?
Regards,
Haribabu Kommi
Fujitsu Australia
Attachments:
0001-Another-use-case-of-logical-replication.patchapplication/octet-stream; name=0001-Another-use-case-of-logical-replication.patchDownload
From d322bb8fb316ad0c1d94267942d370ac04055b2c Mon Sep 17 00:00:00 2001
From: Hari Babu <kommi.haribabu@gmail.com>
Date: Wed, 13 Jun 2018 11:36:59 +1000
Subject: [PATCH] Another use case of logical replication
Logical replication supports the cross platform
PostgreSQL instances to replicate the data, but it is not
clearly mentioned in the docs. IMO it is better to list
out this use case expliclity.
---
doc/src/sgml/logical-replication.sgml | 7 +++++++
1 file changed, 7 insertions(+)
diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml
index 16ba9c4081..3d49cc9a20 100644
--- a/doc/src/sgml/logical-replication.sgml
+++ b/doc/src/sgml/logical-replication.sgml
@@ -64,6 +64,13 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Replicating between cross platform PostgreSQL instances (for example
+ Linux to Windows)
+ </para>
+ </listitem>
+
<listitem>
<para>
Giving access to replicated data to different groups of users.
--
2.16.1.windows.4
On Wed, Jun 13, 2018 at 11:42:14AM +1000, Haribabu Kommi wrote:
On Tue, Jun 12, 2018 at 1:29 PM Craig Ringer <craig@2ndquadrant.com> wrote:
On 12 June 2018 at 11:04, Haribabu Kommi <kommi.haribabu@gmail.com> wrote:
Hi All,
I am not able to find any docs suggesting that PostgreSQL logical
replication supports
cross platform servers (windows --> Linux or vice-versa).It should. I don't think there's buildfarm coverage yet, though.�
Thanks for the confirmation.
This is a good use case that must be explicitly mentioned in the docs.
How about the attached patch?
OK, doc patch added to git head. Let me know if I should back patch it
further. Thanks.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +On Sun, Jun 24, 2018 at 6:36 AM Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Jun 13, 2018 at 11:42:14AM +1000, Haribabu Kommi wrote:
Thanks for the confirmation.
This is a good use case that must be explicitly mentioned in the docs.
How about the attached patch?OK, doc patch added to git head. Let me know if I should back patch it
further. Thanks.
Thanks for the commit.
Yes, it needs to be back patched till 10 stable.
Regards,
Haribabu Kommi
Fujitsu Australia
On Wed, Jun 27, 2018 at 11:16:07PM +1000, Haribabu Kommi wrote:
On Sun, Jun 24, 2018 at 6:36 AM Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Jun 13, 2018 at 11:42:14AM +1000, Haribabu Kommi wrote:
Thanks for the confirmation.
This is a good use case that must be explicitly mentioned in the docs.
How about the attached patch?OK, doc patch added to git head.� Let me know if I should back patch it
further.� Thanks.�
Thanks for the commit.�
Yes, it needs to be back patched till 10 stable.
Sure, done, thanks.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +On Thu, Jun 28, 2018 at 11:12 PM Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Jun 27, 2018 at 11:16:07PM +1000, Haribabu Kommi wrote:
On Sun, Jun 24, 2018 at 6:36 AM Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Jun 13, 2018 at 11:42:14AM +1000, Haribabu Kommi wrote:
Thanks for the confirmation.
This is a good use case that must be explicitly mentioned in thedocs.
How about the attached patch?
OK, doc patch added to git head. Let me know if I should back patch
it
further. Thanks.
Thanks for the commit.
Yes, it needs to be back patched till 10 stable.Sure, done, thanks.
Thanks.
Regards,
Haribabu Kommi
Fujitsu Australia