pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhelp requested on archive_command
2+ messages / 2 participants
[nested] [flat]
* help requested on archive_command
@ 2019-02-15 15:30 Mark Steben <mark.steben@drivedominion.com>
2019-02-15 15:36 ` Re: help requested on archive_command Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 2+ messages in thread
From: Mark Steben @ 2019-02-15 15:30 UTC (permalink / raw)
To: 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;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: help requested on archive_command
2019-02-15 15:30 help requested on archive_command Mark Steben <mark.steben@drivedominion.com>
@ 2019-02-15 15:36 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Achilleas Mantzios @ 2019-02-15 15:36 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-02-15 15:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-02-15 15:30 help requested on archive_command Mark Steben <mark.steben@drivedominion.com>
2019-02-15 15:36 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
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