I use Barman, and I am happy with it.
Just in case you want to try different tools,
https://github.com/dhamaniasad/awesome-postgres.
On Thu, Apr 19, 2018 at 2:48 PM, Edmundo Robles
wrote:
> Yes, you are right, the replication is not a backup ;) , actually i
> backup database daily at 3:0
On Thu, Apr 19, 2018 at 8:48 PM, Edmundo Robles wrote:
> Yes, you are right, the replication is not a backup ;) , actually i
> backup database daily at 3:00 am but if database crash, the amount of
> data is big! that is the reason i want to replicate to reduce the data
> loss. By t
Hi,
If you want to reduce the amount of data lost, you might want to
consider another type of backup :
https://www.postgresql.org/docs/current/static/continuous-archiving.html
That awsome tool can also help you with it : https://pgbackrest.org/
On 04/19/2018 08:48 PM, Edmundo Robles wrote:
> Ye
Yes, you are right, the replication is not a backup ;) , actually i
backup database daily at 3:00 am but if database crash, the amount of
data is big! that is the reason i want to replicate to reduce the data
loss. By the way a few days ago a job partner did a delete with no where.
O
Am 19.04.2018 um 19:57 schrieb Edmundo Robles:
I will use replication as simple backup.
please keep in mind, replication is not a backup. All logical errors on
the master (delete from table and forgot the where-condition) will
replicated to the standby.
Andreas
--
2ndQuadrant - The Post
On 04/19/2018 10:57 AM, Edmundo Robles wrote:
I have several versions of postgres 9.4.5, 9.4.4, 9.4.15 (3), 9.5.3
in 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Â
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
I have several versions of postgres 9.4.5, 9.4.4, 9.4.15 (3), 9.5.3
in 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 1
