Re: help requested on archive_command - Mailing list pgsql-admin

From Achilleas Mantzios
Subject Re: help requested on archive_command
Date
Msg-id fdff419b-194a-812e-b890-860051200bfb@matrix.gatewaynet.com
Whole thread Raw
In response to help requested on archive_command  (Mark Steben <mark.steben@drivedominion.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Mark Steben
Date:
Subject: help requested on archive_command
Next
From: Tom Lane
Date:
Subject: Re: Table Drop Error