Search Postgresql Archives

Re: Doubts about replication..

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

On Thu, Apr 19, 2018 at 1:33 PM, Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> wrote:


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 PostgreSQL Support Company.
www.2ndQuadrant.com





--


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux