Lists: | pgsql-hackers |
---|
From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | pg_receivexlog stops upon server restart |
Date: | 2012-04-06 00:07:03 |
Message-ID: | CAA-aLv58L6erSgNpnWU6Q-Ebe3LGajnneUzytePY65KdZYg5NA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hi,
I've tried out pg_receivexlog and have noticed that when restarting
the cluster, pg_receivexlog gets cut off... it doesn't keep waiting.
This is surprising as the DBA would have to remember to start
pg_receivexlog up again.
--
Thom
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_receivexlog stops upon server restart |
Date: | 2012-04-10 20:07:47 |
Message-ID: | CABUevEwN+8uUg-KkQV-p5f3CXwFA3Sh+bjctCG_nwNS=W9xmVg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Friday, April 6, 2012, Thom Brown wrote:
> Hi,
>
> I've tried out pg_receivexlog and have noticed that when restarting
> the cluster, pg_receivexlog gets cut off... it doesn't keep waiting.
> This is surprising as the DBA would have to remember to start
> pg_receivexlog up again.
>
>
This is intentional as far as that's how the code was written, there's not
a malfunctioning piece of code somewhere.
It would probably make sense to have an auto-reconnect feature, and to have
an option to turn it on/off.
If you haven't already (my wifi here is currently quite useless, which is
why I'm working on my email backlog, so I can't check), please add it to
the open items list.
//Magnus
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_receivexlog stops upon server restart |
Date: | 2012-04-19 11:00:18 |
Message-ID: | CAA-aLv54C2=0np0rsbmJHGUVa8KOvm5a1ssOo2pAm_A4+WuKHA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 10 April 2012 21:07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Friday, April 6, 2012, Thom Brown wrote:
>>
>> Hi,
>>
>> I've tried out pg_receivexlog and have noticed that when restarting
>> the cluster, pg_receivexlog gets cut off... it doesn't keep waiting.
>> This is surprising as the DBA would have to remember to start
>> pg_receivexlog up again.
>>
>
> This is intentional as far as that's how the code was written, there's not a
> malfunctioning piece of code somewhere.
>
> It would probably make sense to have an auto-reconnect feature, and to have
> an option to turn it on/off.
>
> If you haven't already (my wifi here is currently quite useless, which is
> why I'm working on my email backlog, so I can't check), please add it to the
> open items list.
I think it would also be useful to add a paragraph to the
documentation stating use-cases for this feature, and its advantages.
--
Thom
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_receivexlog stops upon server restart |
Date: | 2012-05-24 12:05:14 |
Message-ID: | CABUevEzwfXJ_UsKUVVk0F8QhNoACseQLSORGptV52oP_JB0phg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Thu, Apr 19, 2012 at 1:00 PM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 10 April 2012 21:07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> On Friday, April 6, 2012, Thom Brown wrote:
>>>
>>> Hi,
>>>
>>> I've tried out pg_receivexlog and have noticed that when restarting
>>> the cluster, pg_receivexlog gets cut off... it doesn't keep waiting.
>>> This is surprising as the DBA would have to remember to start
>>> pg_receivexlog up again.
>>>
>>
>> This is intentional as far as that's how the code was written, there's not a
>> malfunctioning piece of code somewhere.
>>
>> It would probably make sense to have an auto-reconnect feature, and to have
>> an option to turn it on/off.
>>
>> If you haven't already (my wifi here is currently quite useless, which is
>> why I'm working on my email backlog, so I can't check), please add it to the
>> open items list.
>
> I think it would also be useful to add a paragraph to the
> documentation stating use-cases for this feature, and its advantages.
Attached is a patch that implements this. Seems reasonable?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
Attachment | Content-Type | Size |
---|---|---|
pg_receivexlog_loop.patch | application/octet-stream | 4.9 KB |
From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_receivexlog stops upon server restart |
Date: | 2012-05-24 12:34:18 |
Message-ID: | CAA-aLv7w61DiQRGamnnZALTpqg18eYGpq+bVeJiyNDii_qLJYQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 24 May 2012 13:05, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Thu, Apr 19, 2012 at 1:00 PM, Thom Brown <thom(at)linux(dot)com> wrote:
>> On 10 April 2012 21:07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>>> On Friday, April 6, 2012, Thom Brown wrote:
>>>>
>>>> Hi,
>>>>
>>>> I've tried out pg_receivexlog and have noticed that when restarting
>>>> the cluster, pg_receivexlog gets cut off... it doesn't keep waiting.
>>>> This is surprising as the DBA would have to remember to start
>>>> pg_receivexlog up again.
>>>>
>>>
>>> This is intentional as far as that's how the code was written, there's not a
>>> malfunctioning piece of code somewhere.
>>>
>>> It would probably make sense to have an auto-reconnect feature, and to have
>>> an option to turn it on/off.
>>>
>>> If you haven't already (my wifi here is currently quite useless, which is
>>> why I'm working on my email backlog, so I can't check), please add it to the
>>> open items list.
>>
>> I think it would also be useful to add a paragraph to the
>> documentation stating use-cases for this feature, and its advantages.
>
> Attached is a patch that implements this. Seems reasonable?
s/non fatal/non-fatal/
Yes, this solves the problem for me, except you forgot to translate
noloop in long_options[] . :)
--
Thom
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_receivexlog stops upon server restart |
Date: | 2012-05-24 12:37:51 |
Message-ID: | CABUevEyOAucRE0MdM46tgzhvDw9ihmwzm-5O=6nsXN5BBs9CnA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Thu, May 24, 2012 at 2:34 PM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 24 May 2012 13:05, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> On Thu, Apr 19, 2012 at 1:00 PM, Thom Brown <thom(at)linux(dot)com> wrote:
>>> On 10 April 2012 21:07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>>>> On Friday, April 6, 2012, Thom Brown wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> I've tried out pg_receivexlog and have noticed that when restarting
>>>>> the cluster, pg_receivexlog gets cut off... it doesn't keep waiting.
>>>>> This is surprising as the DBA would have to remember to start
>>>>> pg_receivexlog up again.
>>>>>
>>>>
>>>> This is intentional as far as that's how the code was written, there's not a
>>>> malfunctioning piece of code somewhere.
>>>>
>>>> It would probably make sense to have an auto-reconnect feature, and to have
>>>> an option to turn it on/off.
>>>>
>>>> If you haven't already (my wifi here is currently quite useless, which is
>>>> why I'm working on my email backlog, so I can't check), please add it to the
>>>> open items list.
>>>
>>> I think it would also be useful to add a paragraph to the
>>> documentation stating use-cases for this feature, and its advantages.
>>
>> Attached is a patch that implements this. Seems reasonable?
>
> s/non fatal/non-fatal/
>
> Yes, this solves the problem for me, except you forgot to translate
> noloop in long_options[] . :)
Fixed :-)
Did you test it, or just assumed it worked? ;)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_receivexlog stops upon server restart |
Date: | 2012-05-24 12:44:25 |
Message-ID: | CAA-aLv6usUdLSuGiTPtkRzh9NprQUSQzh88_94gx6g018aDqaw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 24 May 2012 13:37, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Thu, May 24, 2012 at 2:34 PM, Thom Brown <thom(at)linux(dot)com> wrote:
>> On 24 May 2012 13:05, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>>> On Thu, Apr 19, 2012 at 1:00 PM, Thom Brown <thom(at)linux(dot)com> wrote:
>>>> On 10 April 2012 21:07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>>>>> On Friday, April 6, 2012, Thom Brown wrote:
>>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I've tried out pg_receivexlog and have noticed that when restarting
>>>>>> the cluster, pg_receivexlog gets cut off... it doesn't keep waiting.
>>>>>> This is surprising as the DBA would have to remember to start
>>>>>> pg_receivexlog up again.
>>>>>>
>>>>>
>>>>> This is intentional as far as that's how the code was written, there's not a
>>>>> malfunctioning piece of code somewhere.
>>>>>
>>>>> It would probably make sense to have an auto-reconnect feature, and to have
>>>>> an option to turn it on/off.
>>>>>
>>>>> If you haven't already (my wifi here is currently quite useless, which is
>>>>> why I'm working on my email backlog, so I can't check), please add it to the
>>>>> open items list.
>>>>
>>>> I think it would also be useful to add a paragraph to the
>>>> documentation stating use-cases for this feature, and its advantages.
>>>
>>> Attached is a patch that implements this. Seems reasonable?
>>
>> s/non fatal/non-fatal/
>>
>> Yes, this solves the problem for me, except you forgot to translate
>> noloop in long_options[] . :)
> Fixed :-)
>
> Did you test it, or just assumed it worked? ;)
How very dare you. Of course I tested it. It successfully reconnects
on multiple restarts, checks intermittently when I've stopped the
server, showing the connection error message, successfully continues
when I eventually bring the server back up, and doesn't attempt a
reconnect when using -n.
So looks good to me.
--
Thom
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_receivexlog stops upon server restart |
Date: | 2012-05-27 09:07:41 |
Message-ID: | CABUevExy69bFYfL30YYd_Ooot7Opxh=oSTZ_r-3gFDWbD=0Mow@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Thursday, May 24, 2012, Thom Brown wrote:
> On 24 May 2012 13:37, Magnus Hagander <magnus(at)hagander(dot)net <javascript:;>>
> wrote:
> > On Thu, May 24, 2012 at 2:34 PM, Thom Brown <thom(at)linux(dot)com<javascript:;>>
> wrote:
> >> On 24 May 2012 13:05, Magnus Hagander <magnus(at)hagander(dot)net<javascript:;>>
> wrote:
> >>> On Thu, Apr 19, 2012 at 1:00 PM, Thom Brown <thom(at)linux(dot)com<javascript:;>>
> wrote:
> >>>> On 10 April 2012 21:07, Magnus Hagander <magnus(at)hagander(dot)net<javascript:;>>
> wrote:
> >>>>> On Friday, April 6, 2012, Thom Brown wrote:
> >>>>>>
> >>>>>> Hi,
> >>>>>>
> >>>>>> I've tried out pg_receivexlog and have noticed that when restarting
> >>>>>> the cluster, pg_receivexlog gets cut off... it doesn't keep waiting.
> >>>>>> This is surprising as the DBA would have to remember to start
> >>>>>> pg_receivexlog up again.
> >>>>>>
> >>>>>
> >>>>> This is intentional as far as that's how the code was written,
> there's not a
> >>>>> malfunctioning piece of code somewhere.
> >>>>>
> >>>>> It would probably make sense to have an auto-reconnect feature, and
> to have
> >>>>> an option to turn it on/off.
> >>>>>
> >>>>> If you haven't already (my wifi here is currently quite useless,
> which is
> >>>>> why I'm working on my email backlog, so I can't check), please add
> it to the
> >>>>> open items list.
> >>>>
> >>>> I think it would also be useful to add a paragraph to the
> >>>> documentation stating use-cases for this feature, and its advantages.
> >>>
> >>> Attached is a patch that implements this. Seems reasonable?
> >>
> >> s/non fatal/non-fatal/
> >>
> >> Yes, this solves the problem for me, except you forgot to translate
> >> noloop in long_options[] . :)
> > Fixed :-)
> >
> > Did you test it, or just assumed it worked? ;)
>
> How very dare you. Of course I tested it. It successfully reconnects
> on multiple restarts, checks intermittently when I've stopped the
> server, showing the connection error message, successfully continues
> when I eventually bring the server back up, and doesn't attempt a
> reconnect when using -n.
>
> So looks good to me.
>
Thanks - applied!
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/