Re: Doubts about replication..

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/

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@a-kretschmer.de> 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

--

-- 
Stefan FERCOT
http://dalibo.com - http://dalibo.org