On Thu, 1 Dec 2016 20:11:06 +0100
Benoit Lobréau <benoit.lobr...@gmail.com> wrote:
> 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:
> 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.
Sent via pgsql-general mailing list (firstname.lastname@example.org)
To make changes to your subscription: