Re: Doubts about replication..
You want the replication for backup purposes. What is the use case for your backups: Is it disaster recovery? Is it archiving historical data? Is it failover? Is it off-site backup?
If you outline your needs then the proper solution can be offered. There are other methods than just using the built-in binary file replication.
Based on your use of the words "as simple backup" it seems to me you would be better off just using pg_dump periodically to copy the database to the backup system. I would use the same version of pg_dump as the database for maximal compatibility on restoring to that version.
As for your versions, all of the 9.4.x should be upgraded to the latest 9.4.x release there is. This is a simple upgrade and restart, and very safe to do. You will get many fixed bugs, some of which could cause data loss. Similarly for the 9.5.x release.
On Thu, Apr 19, 2018 at 1:57 PM, Edmundo Robles <edmundo@sw-argos.com> wrote:
--I have several versions of postgres 9.4.5, 9.4.4, 9.4.15 (3), 9.5.3in different versions of Debian 7.6, 7.8, 7.11, 8.5 and 8.6.I need to replicate the databases and I have clear that I must update all to one version.My main question is, Do you recommended me update to 9.6 or better update to 10?.Actually, is not the goal have high availability . I will use replication as simple backup.For reasons of $$$ I can only have 1 server in which I will replicate the 6 databases.Do you recommend using a postgres service for the 6 databases?, or better, I think, I must run a postgres service in different ports, for each database?.thanks in advance.regards!
В списке pgsql-general по дате отправления:
Предыдущее
От: Adrian KlaverДата:
Сообщение: Re: Problem with trigger makes Detail record be invalid