| From: | Jehan-Guillaume de Rorthais <ioguix(at)free(dot)fr> |
|---|---|
| To: | Benoit Lobréau <benoit(dot)lobreau(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Replication between différent versions of the same OS. |
| Date: | 2016-12-01 19:47:48 |
| Message-ID: | 20161201204748.57e297e9@firost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 1 Dec 2016 20:11:06 +0100
Benoit Lobréau <benoit(dot)lobreau(at)gmail(dot)com> wrote:
> Hi,
>
> Is it possible to use the built in replication to replicate between two
> PostgreSQL in the same version but in different version of the same OS (Say
> Pg 9.1 Ubuntu 12 to Pg 9.1 Ubuntu 14)
>
> I think I read in Hackers that since PostgreSQL uses the OS libraries for
> encoding. It could cause silent corruption because the encoding might be
> different between versions of the OS. But I cant find the email again so I
> can't find the exact context ... maybe I dreamed it ..
No, you did not. See:
https://www.postgresql.org/message-id/flat/BA6132ED-1F6B-4A0B-AC22-81278F5AB81E%40tripadvisor(dot)com#BA6132ED-1F6B-4A0B-AC22-81278F5AB81E(at)tripadvisor(dot)com
> We would like to replicate to the other server then upgrade to a newer
> version. (the import is too long)
Use logical replication. You could use Slony for example.
Regards,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benoit Lobréau | 2016-12-01 23:45:39 | Re: [GENERAL] [GENERAL] Replication between différent versions of the same OS. |
| Previous Message | Benoit Lobréau | 2016-12-01 19:11:06 | [GENERAL] Replication between différent versions of the same OS. |