public inbox for [email protected]
help / color / mirror / Atom feedpg_standby supported versions
6+ messages / 3 participants
[nested] [flat]
* pg_standby supported versions
@ 2008-08-13 09:59 Mark Kirkwood <[email protected]>
2008-08-22 05:50 ` Re: pg_standby supported versions Decibel! <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Mark Kirkwood @ 2008-08-13 09:59 UTC (permalink / raw)
To: pgsql-docs
I noticed in the docs for pg_standby (docs/src/sgml/pgstandby.sgml) that
we have supported version >= 8.2. However it does seem to work ok with
earlier versions (e.g 8.1) - or am I missing something?
cheers
Mark
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_standby supported versions
2008-08-13 09:59 pg_standby supported versions Mark Kirkwood <[email protected]>
@ 2008-08-22 05:50 ` Decibel! <[email protected]>
2008-08-26 09:30 ` Re: pg_standby supported versions Simon Riggs <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Decibel! @ 2008-08-22 05:50 UTC (permalink / raw)
To: Mark Kirkwood <[email protected]>; Simon Riggs <[email protected]>; +Cc: pgsql-docs
On Aug 13, 2008, at 4:59 AM, Mark Kirkwood wrote:
> I noticed in the docs for pg_standby (docs/src/sgml/pgstandby.sgml)
> that we have supported version >= 8.2. However it does seem to work
> ok with earlier versions (e.g 8.1) - or am I missing something?
Hrm, AFAIK it works... Simon?
--
Decibel!, aka Jim C. Nasby, Database Architect [email protected]
Give your computer some brain candy! www.distributed.net Team #1828
Attachments:
[application/pkcs7-signature] smime.p7s (2.5K, 2-smime.p7s)
download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_standby supported versions
2008-08-13 09:59 pg_standby supported versions Mark Kirkwood <[email protected]>
2008-08-22 05:50 ` Re: pg_standby supported versions Decibel! <[email protected]>
@ 2008-08-26 09:30 ` Simon Riggs <[email protected]>
2008-11-26 09:14 ` Re: pg_standby supported versions Mark Kirkwood <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Simon Riggs @ 2008-08-26 09:30 UTC (permalink / raw)
To: Decibel! <[email protected]>; +Cc: Mark Kirkwood <[email protected]>; pgsql-docs
On Fri, 2008-08-22 at 00:50 -0500, Decibel! wrote:
> On Aug 13, 2008, at 4:59 AM, Mark Kirkwood wrote:
> > I noticed in the docs for pg_standby (docs/src/sgml/pgstandby.sgml)
> > that we have supported version >= 8.2. However it does seem to work
> > ok with earlier versions (e.g 8.1) - or am I missing something?
>
> Hrm, AFAIK it works... Simon?
It works, yes. But in basic form only.
You'll have problems stopping and starting standby, but the most
important change is that the process is not restartable. So if you run
it for a month and then crash, you'll need to re-run the whole month's
WAL data.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_standby supported versions
2008-08-13 09:59 pg_standby supported versions Mark Kirkwood <[email protected]>
2008-08-22 05:50 ` Re: pg_standby supported versions Decibel! <[email protected]>
2008-08-26 09:30 ` Re: pg_standby supported versions Simon Riggs <[email protected]>
@ 2008-11-26 09:14 ` Mark Kirkwood <[email protected]>
2008-11-27 17:11 ` Re: pg_standby supported versions Simon Riggs <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Mark Kirkwood @ 2008-11-26 09:14 UTC (permalink / raw)
To: Simon Riggs <[email protected]>; +Cc: Decibel! <[email protected]>; pgsql-docs
Simon Riggs wrote:
> On Fri, 2008-08-22 at 00:50 -0500, Decibel! wrote:
>
>> On Aug 13, 2008, at 4:59 AM, Mark Kirkwood wrote:
>>
>>> I noticed in the docs for pg_standby (docs/src/sgml/pgstandby.sgml)
>>> that we have supported version >= 8.2. However it does seem to work
>>> ok with earlier versions (e.g 8.1) - or am I missing something?
>>>
>> Hrm, AFAIK it works... Simon?
>>
>
> It works, yes. But in basic form only.
>
> You'll have problems stopping and starting standby, but the most
> important change is that the process is not restartable. So if you run
> it for a month and then crash, you'll need to re-run the whole month's
> WAL data.
>
>
Exactly, after posting this I discovered the relevant CVS logs for
changes to support restartable recovery. It seems to me that perhaps a
little more detail in the docs would be good here.
At work some folks are using pg_standby with 8.1 and while it does work
quite well, it took me a wee while to figure out that some of the issues
they are having are tied up with inability to continue recovery after
restarting the database or the os!
Best wishes
Mark
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_standby supported versions
2008-08-13 09:59 pg_standby supported versions Mark Kirkwood <[email protected]>
2008-08-22 05:50 ` Re: pg_standby supported versions Decibel! <[email protected]>
2008-08-26 09:30 ` Re: pg_standby supported versions Simon Riggs <[email protected]>
2008-11-26 09:14 ` Re: pg_standby supported versions Mark Kirkwood <[email protected]>
@ 2008-11-27 17:11 ` Simon Riggs <[email protected]>
2008-11-27 18:56 ` Re: pg_standby supported versions Mark Kirkwood <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Simon Riggs @ 2008-11-27 17:11 UTC (permalink / raw)
To: Mark Kirkwood <[email protected]>; +Cc: Decibel! <[email protected]>; pgsql-docs
On Wed, 2008-11-26 at 22:14 +1300, Mark Kirkwood wrote:
> Simon Riggs wrote:
> >
> > You'll have problems stopping and starting standby, but the most
> > important change is that the process is not restartable. So if you
> run
> > it for a month and then crash, you'll need to re-run the whole
> month's
> > WAL data.
> >
> >
> Exactly, after posting this I discovered the relevant CVS logs for
> changes to support restartable recovery. It seems to me that perhaps a
> little more detail in the docs would be good here.
I would hope that the complete absence of anything would be all that is
required to dissuade people. We don't ever update the docs to say "BTW
feature X is not supported until next release". Not sure we should start
now.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_standby supported versions
2008-08-13 09:59 pg_standby supported versions Mark Kirkwood <[email protected]>
2008-08-22 05:50 ` Re: pg_standby supported versions Decibel! <[email protected]>
2008-08-26 09:30 ` Re: pg_standby supported versions Simon Riggs <[email protected]>
2008-11-26 09:14 ` Re: pg_standby supported versions Mark Kirkwood <[email protected]>
2008-11-27 17:11 ` Re: pg_standby supported versions Simon Riggs <[email protected]>
@ 2008-11-27 18:56 ` Mark Kirkwood <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Mark Kirkwood @ 2008-11-27 18:56 UTC (permalink / raw)
To: Simon Riggs <[email protected]>; +Cc: Decibel! <[email protected]>; pgsql-docs
Simon Riggs wrote:
> On Wed, 2008-11-26 at 22:14 +1300, Mark Kirkwood wrote:
>
>>
>> Exactly, after posting this I discovered the relevant CVS logs for
>> changes to support restartable recovery. It seems to me that perhaps a
>> little more detail in the docs would be good here.
>>
>
> I would hope that the complete absence of anything would be all that is
> required to dissuade people. We don't ever update the docs to say "BTW
> feature X is not supported until next release". Not sure we should start
> now.
>
>
While I understand, I also think it is perfectly reasonable to clarify
why a specific minimum version is being recommended. To me this conforms
to the open source spirit of telling folk why something is true, as
opposed to stating that it is.
I'm thinking of something like:
<para>
pg_standby is designed to work with PostgreSQL 8.2 and later, as it
requires the ability to interrupt and restart recovery (absent in
earlier server versions).
</para>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2008-11-27 18:56 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-13 09:59 pg_standby supported versions Mark Kirkwood <[email protected]>
2008-08-22 05:50 ` Decibel! <[email protected]>
2008-08-26 09:30 ` Simon Riggs <[email protected]>
2008-11-26 09:14 ` Mark Kirkwood <[email protected]>
2008-11-27 17:11 ` Simon Riggs <[email protected]>
2008-11-27 18:56 ` Mark Kirkwood <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox