Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-06 Thread Ian Harding
On Tue, Nov 6, 2012 at 5:45 AM, Kevin Grittner wrote: > Darren Duncan wrote: > > Ian Harding wrote: > > >> It says everything is happy as normal... > >> > >> 2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48 > > > > What does this log line mean? Is that "happy as normal"? >

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-06 Thread Kevin Grittner
Darren Duncan wrote: > Ian Harding wrote: >> It says everything is happy as normal... >> >> 2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48 > > What does this log line mean? Is that "happy as normal"? Note that the message level is LOG, not WARNING or ERROR or anything

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Darren Duncan
Ian Harding wrote: On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman wrote: It says everything is happy as normal... 2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48 What does this log line mean? Is that "happy as normal"? -- Darren Duncan -- Sent via pgsql-general

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Lonni J Friedman
On Mon, Nov 5, 2012 at 8:31 PM, Ian Harding wrote: > > > > On Mon, Nov 5, 2012 at 8:15 PM, Lonni J Friedman wrote: >> >> On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote: >> > >> > >> > >> > On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman >> > wrote: >> >> >> >> On Mon, Nov 5, 2012 at 7:49 PM

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Ian Harding
On Mon, Nov 5, 2012 at 8:15 PM, Lonni J Friedman wrote: > On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote: > > > > > > > > On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman > wrote: > >> > >> On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding > wrote: > >> > > >> > > >> > On Mon, Nov 5, 2012 at 7:46

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Lonni J Friedman
On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote: > > > > On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman wrote: >> >> On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote: >> > >> > >> > On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman >> > wrote: >> >> >> >> On Mon, Nov 5, 2012 at 7:40 PM, Ian

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Ian Harding
On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman wrote: > On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote: > > > > > > On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman > wrote: > >> > >> On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding > wrote: > >> > I had a 9.0.8 hot standby setup, one master,

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Lonni J Friedman
On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote: > > > On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman wrote: >> >> On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote: >> > I had a 9.0.8 hot standby setup, one master, two slaves, working great. >> > Then, I tried to re-initialize by making a b

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Ian Harding
On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman wrote: > On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote: > > I had a 9.0.8 hot standby setup, one master, two slaves, working great. > > Then, I tried to re-initialize by making a base backup, the way I've > done it > > many times before, but f

Re: [GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Lonni J Friedman
On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote: > I had a 9.0.8 hot standby setup, one master, two slaves, working great. > Then, I tried to re-initialize by making a base backup, the way I've done it > many times before, but for some reason I can't get the standby to accept > connections. I c

[GENERAL] Hot Standby Not So Hot Anymore

2012-11-05 Thread Ian Harding
I had a 9.0.8 hot standby setup, one master, two slaves, working great. Then, I tried to re-initialize by making a base backup, the way I've done it many times before, but for some reason I can't get the standby to accept connections. I copied the postgresql.conf and recorvery.conf out of the way,