Re: (multiplatform) replication problem

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "W(dot)P(dot)" <laurentp(at)wp(dot)pl>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: (multiplatform) replication problem
Date: 2019-01-09 16:27:37
Message-ID: CAMkU=1zBbcMd5Xk4X_jojq4Aj=p+SW8ug1cCnFPGQJddshbYTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 8, 2019 at 10:49 AM W.P. <laurentp(at)wp(dot)pl> wrote:

> Hi there,
> I have following setup:
> - master database, 9.5.7, on I386 (Pentium M),
> now i want to replicate database to:
> - slave database. 9.5.7 on armhf (OrangePiPC+).
> Is in possible?
>

I think the error message is telling you that physical replication is not
possible across platforms as different as this. You could go through the
output of pg_controldata line by line to see what the differences are.
Although perhaps someone can just tell you off the top of their head.

Perhaps you can use logical replication instead, but to do that you should
probably upgrade your PostgreSQL version to at least v10.

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message github kran 2019-01-09 17:02:01 Re: Pulling data from Postgres DB table for every 5 seconds.
Previous Message Sergei Kornilov 2019-01-09 11:11:58 Re: ALTER TABLE with multiple SET NOT NULL