Re: [GENERAL] Pausing log shipping for streaming replication

2014-12-17 Thread Sameer Kumar
On Tue, Dec 16, 2014 at 11:36 PM, Joseph Kregloh wrote: > > archive_command: > archive_command = '/usr/local/pgsql/data/log_shipper.sh "%p" "%f"' > > log_shipper.sh > #!/usr/local/bin/bash > rsync -a $1 pgprod@prod-db-slave:archive/$2 < /dev/null; > rsync -a $1 pgprod@prod-db-slave:p3_wal_files/$2

Re: [GENERAL] Pausing log shipping for streaming replication

2014-12-16 Thread Joseph Kregloh
On Mon, Dec 15, 2014 at 7:12 PM, Sameer Kumar wrote: > > On 16 Dec 2014 01:13, "Joseph Kregloh" wrote: > > > > Hello, > > > > I have a master multi slave streaming replication setup. One master and > two slaves. I need to do some maintenance on one of the slaves as one of > the drives died howev

Re: [GENERAL] Pausing log shipping for streaming replication

2014-12-15 Thread Sameer Kumar
On 16 Dec 2014 01:13, "Joseph Kregloh" wrote: > > Hello, > > I have a master multi slave streaming replication setup. One master and two slaves. I need to do some maintenance on one of the slaves as one of the drives died however there is some other weird things going on in that array that I would

Re: [GENERAL] Pausing log shipping for streaming replication

2014-12-15 Thread Joseph Kregloh
On Mon, Dec 15, 2014 at 2:18 PM, Patrick Krecker wrote: > On Mon, Dec 15, 2014 at 10:29 AM, Joseph Kregloh > wrote: > > > > > > On Mon, Dec 15, 2014 at 12:59 PM, Patrick Krecker > > wrote: > >> > >> On Mon, Dec 15, 2014 at 9:12 AM, Joseph Kregloh < > jkreg...@sproutloud.com> > >> wrote: > >> >

Re: [GENERAL] Pausing log shipping for streaming replication

2014-12-15 Thread Andy Colson
On 12/15/2014 11:12 AM, Joseph Kregloh wrote: Hello, I have a master multi slave streaming replication setup. One master and two slaves. I need to do some maintenance on one of the slaves as one of the drives died however there is some other weird things going on in that array that I would need

Re: [GENERAL] Pausing log shipping for streaming replication

2014-12-15 Thread Patrick Krecker
On Mon, Dec 15, 2014 at 10:29 AM, Joseph Kregloh wrote: > > > On Mon, Dec 15, 2014 at 12:59 PM, Patrick Krecker > wrote: >> >> On Mon, Dec 15, 2014 at 9:12 AM, Joseph Kregloh >> wrote: >> > Hello, >> > >> > I have a master multi slave streaming replication setup. One master and >> > two >> > sla

Re: [GENERAL] Pausing log shipping for streaming replication

2014-12-15 Thread Joseph Kregloh
On Mon, Dec 15, 2014 at 12:59 PM, Patrick Krecker wrote: > On Mon, Dec 15, 2014 at 9:12 AM, Joseph Kregloh > wrote: > > Hello, > > > > I have a master multi slave streaming replication setup. One master and > two > > slaves. I need to do some maintenance on one of the slaves as one of the > > dr

Re: [GENERAL] Pausing log shipping for streaming replication

2014-12-15 Thread Patrick Krecker
On Mon, Dec 15, 2014 at 9:12 AM, Joseph Kregloh wrote: > Hello, > > I have a master multi slave streaming replication setup. One master and two > slaves. I need to do some maintenance on one of the slaves as one of the > drives died however there is some other weird things going on in that array >

[GENERAL] Pausing log shipping for streaming replication

2014-12-15 Thread Joseph Kregloh
Hello, I have a master multi slave streaming replication setup. One master and two slaves. I need to do some maintenance on one of the slaves as one of the drives died however there is some other weird things going on in that array that I would need to investigate. So I am expecting the machine to