From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: help requested on archive_command
Date: Fri, 15 Feb 2019 17:36:57 +0200
Message-ID: <fdff419b-194a-812e-b890-860051200bfb@matrix.gatewaynet.com> (raw)
In-Reply-To: <CADyzmyzr6d+KK2twjn+spYz4gkSRGx8bScVzjPsVTM--Qe4ioQ@mail.gmail.com>
References: <CADyzmyzr6d+KK2twjn+spYz4gkSRGx8bScVzjPsVTM--Qe4ioQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: help requested on archive_command
In-Reply-To: <fdff419b-194a-812e-b890-860051200bfb@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox