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/>
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 |