Re: Master slave replication

Fabio Pardi <f.pardi@xxxxxxxxxxxx> · Wed, 19 Sep 2018 12:14:30 +0200



    Hi
        Arvind,

        
        From
            what you describe, looks like
              you are sharing WAL and
                archive under the same partition. It is not good idea.

                    
                  A lot depends from how much
            disk space you have available
              and how you setup the disks,
                but from
        what i see, max_wal_size in your configuration is quite big.
              I would set it to something smaller, and
          make sure that archive, data and pg_xlog are on different partitions or better, disks

                
https://www.postgresql.org/docs/9.5/static/runtime-config-wal.html#GUC-MAX-WAL-SIZE

                
                regards,

                    
                    fabio pardi

                  
    On 19/09/18 11:54, arvind chikne wrote:

    
                      Hi All, 
                        

                        I have successfully configured the master
                          slave replication through WAL, but after some
                          time my px_xlog and log_archive gets full is
                          there any option to set the limit for the
                          same 
                        

                        Error
                        
                          cp: error writing
                              '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5':
                              No space left on device
                          2018-09-19 15:19:19 IST [15642-34394]
                              LOG:  archive command failed with exit
                              code 1
                          2018-09-19 15:19:19 IST [15642-34395]
                              DETAIL:  The failed archive command was:
                              cp pg_xlog/00000001000002E0000000D5
                              /var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5
                          cp: error writing
                              '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5':
                              No space left on device
                          2018-09-19 15:19:20 IST [15642-34396]
                              LOG:  archive command failed with exit
                              code 1
                          2018-09-19 15:19:20 IST [15642-34397]
                              DETAIL:  The failed archive command was:
                              cp pg_xlog/00000001000002E0000000D5
                              /var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5
                          2018-09-19 15:19:20 IST [15642-34398]
                              WARNING:  archiving transaction log file
                              "00000001000002E0000000D5" failed too many
                              times, will try again later
                          cp: error writing
                              '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5':
                              No space left on device
                          2018-09-19 15:19:24 IST [15642-34399]
                              LOG:  archive command failed with exit
                              code 1
                          2018-09-19 15:19:24 IST [15642-34400]
                              DETAIL:  The failed archive command was:
                              cp pg_xlog/00000001000002E0000000D5
                              /var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5
                        
                        
                        pls see my postgres.conf
                        
                          max_wal_size = 100GB
                          archive_mode = on

                            
                          archive_command = 'cp %p
                              /var/lib/postgresql/9.5/main/log_archive/%f'

                            
                          max_wal_senders = 5  

                            
                          wal_keep_segments = 32 

                            
                          hot_standby = on

                            
                          My recovery.conf
                          
                            standby_mode = 'on'
                            primary_conninfo =
                                'host=XXX.XXX.XXX.XXX port=5432 user=rep
                                password=REP'
                            

                            trigger_file =
                                '/tmp/postgresql.trigger.5432'
                            restore_command = 'cp
                                /var/lib/postgresql/9.5/main/log_archive/%f
                                "%p"'
                            archive_cleanup_command =
                                'pg_archivecleanup
                                /var/lib/postgresql/9.5/main/log_archive/
                                %r'
                          
                          
                          -- 

                          
                                        Thanks
                                              & Regards

                                            Arvind rao chikne
                                        9818979986

                                        
                                          Think
                                                    Green!!! Please consider your
                                                  environmental
                                                  responsibility before
                                                  printing this e-mail