help requested on archive_command

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: help requested on archive_command
Date: 2019-02-15 15:30:12
Message-ID: CADyzmyzr6d+KK2twjn+spYz4gkSRGx8bScVzjPsVTM--Qe4ioQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

All comments welcome. thank you

--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
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 <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2019-02-15 15:36:57 Re: help requested on archive_command
Previous Message soumik.bhattacharjee 2019-02-15 11:21:26 RE: Table Drop Error