Re: help requested on archive_command

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Fri, 15 Feb 2019 17:36:57 +0200



    On 15/2/19 5:30 μ.μ., Mark Steben
      wrote:

    
      Good morning,
            We run postgres 9.4.  We will be moving two of our
          major databases from our current datacenter to an outsourced
          datacenter.  To do this move I will be using our current
          logshipping application, including a command file executed by
          the archive_command config.  Currently we use this file to
          logship to 2 other servers in our network.  I need to modify
          that command to (temporarily) 2 more servers in the new
          datacenter, making a total of 4.
           My question is: can I concatenate the archive command
          like we can concatenate commands in linux.  So this would look
          like:    'sh /homedirectory/logshipp.to.2.old,sh %p %f  ; sh
          /homedirectory/logshipp.to.2.new.sh % p %f'
            or
        do I need to simply add the 2 new servers to the logshipp.to.2.old.sh
          script?
      
    
    Maybe && would make more sense, if it is mandatory that all
    of them succeed.

    
        All comments welcome.  thank you
        
          
          -- 

          
            Mark Steben
                  

                   Database Administrator

                    @utoRevenue | Autobase 
                    

                      CRM
                      division of Dominion Dealer Solutions 

                    95D Ashley
                      Ave.

                      West Springfield, MA 01089 

                    t: 413.327-3045
                    

                    f: 413.383-9567
                  
            www.fb.com/DominionDealerSolutions

                    www.twitter.com/DominionDealer

                     www.drivedominion.com

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