From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: help requested on archive_command |
Date: | 2019-02-15 15:36:57 |
Message-ID: | fdff419b-194a-812e-b890-860051200bfb@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 <http://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 <http://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 <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 <http://www.fb.com/DominionDealerSolutions>
> www.twitter.com/DominionDealer <http://www.twitter.com/DominionDealer>
> www.drivedominion.com <http://www.autorevenue.com/>
>
>
>
>
>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-02-15 16:02:51 | Re: Table Drop Error |
Previous Message | Mark Steben | 2019-02-15 15:30:12 | help requested on archive_command |