Re: Doubts about replication..

Stefan Fercot <stefan.fercot@xxxxxxxxxx> · Fri, 20 Apr 2018 10:40:14 +0200



    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:

    
      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

                
        -- 

        
    Kind regards,

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

Attachment:
signature.asc

Description: OpenPGP digital signature