Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Mon, 3 Sep 2018 10:09:08 +0300



    On 03/09/2018 08:58, soumitra bhandary
      wrote:

    
        Hi Pavan , 
      
        
        From Log it is evident that data integrity is failing both at
        Publisher and subscriber end . 

      
    At Publisher? how? He does not suggest anything like this. If the
    failure was on the publisher side, you wouldn't even notice this on
    the subscriber side.

    
        This may be due to several reason , so you have to remove that
        conflict first . 
      
        
        2018-08-26 06:32:09.659
          IST [9385] ERROR:  duplicate key value violates 

        unique constraint
          "table_pkey" 

      
        Thanks ,
      
        Soumitra 
      
        
      From:
          pavan95 <pavan.postgresdba@xxxxxxxxx>

          Sent: Monday, September 3, 2018 10:58 AM

          To: pgsql-admin@xxxxxxxxxxxxxx

          Subject: Re: Heavy Logging in Subscriber side when
          configured Logical Replication in 10.4
         
      
            Community,

              
              Looking forward to hear your advices.

              
              --

              Sent from: 
http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

              
    -- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt