From: Simon Riggs on
On Fri, 2010-03-12 at 22:28 -0500, Bruce Momjian wrote:

> Where are we in getting to beta1? I know people are looking to me for
> 9.0 release notes and I will have them done in about a week, but what
> about open issues? I don't see many on the main 9.0 open items page:
>
> http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items#Bugs
>
> The list has been reduced greatly in the past week. What about HS/SR
> open items?

I have these things on my list

* Minor page xid bug fix
* btree delete standby-side derivation of xid
* review of StartupXLog issue, on open items list, has an effect on HS

I expect to be finished with those by Wed, perhaps Thurs.

Some additional open items on SR

* trigger_file no longer supports "fast" mode. There is no way to
startup server quickly if it has fallen behind, as is currently possible
with 8.4

* There should be a default for "trigger_file" so that you can failover
a server even if this has not been specified.

To me the open items look like at least 2 weeks work on SR, given some
of them will likely need discussion rather than just action.

--
Simon Riggs www.2ndQuadrant.com


--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Josh Berkus on

> The list has been reduced greatly in the past week. What about HS/SR
> open items?

I'd like to see vacuum_defer_cleanup_age added to the "Archive" section
of postgresql.conf, and add it to the docs (I'll write something this
week). I'd like to get rid of the associated hint-bits bogus error
messsage.

--Josh Berkus

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Heikki Linnakangas on
Simon Riggs wrote:
> I have these things on my list
>
> * Minor page xid bug fix
> * btree delete standby-side derivation of xid
> * review of StartupXLog issue, on open items list, has an effect on HS
>
> I expect to be finished with those by Wed, perhaps Thurs.

Don't forget the "start from shutdown checkpoint" issue.

> * There should be a default for "trigger_file" so that you can failover
> a server even if this has not been specified.

I disagree. In many cases, you never want to failover the standby, and
having a default would just get in your way.

> To me the open items look like at least 2 weeks work on SR, given some
> of them will likely need discussion rather than just action.

Yeah, I've unfortunately had very little to no time at all on SR
recently. I must reserve some full days for that again...

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Simon Riggs on
On Sun, 2010-03-14 at 16:53 +0200, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > I have these things on my list
> >
> > * Minor page xid bug fix
> > * btree delete standby-side derivation of xid
> > * review of StartupXLog issue, on open items list, has an effect on HS
> >
> > I expect to be finished with those by Wed, perhaps Thurs.
>
> Don't forget the "start from shutdown checkpoint" issue.

How could I? :-)

> > * There should be a default for "trigger_file" so that you can failover
> > a server even if this has not been specified.
>
> I disagree. In many cases, you never want to failover the standby, and
> having a default would just get in your way.

An explanation in the docs would be good. And also a hint of how to
failover if you decide in an emergency that the absence was a mistake,
in retrospect.

> > To me the open items look like at least 2 weeks work on SR, given some
> > of them will likely need discussion rather than just action.
>
> Yeah, I've unfortunately had very little to no time at all on SR
> recently. I must reserve some full days for that again...

12 open items says "yes please" to that.

--
Simon Riggs www.2ndQuadrant.com


--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Josh Berkus on
On 3/14/10 9:02 AM, Simon Riggs wrote:
> An explanation in the docs would be good. And also a hint of how to
> failover if you decide in an emergency that the absence was a mistake,
> in retrospect.

I'm planning on writing a "Guide to HS & SR" for the beta. Originally I
planned to put this in the main docs, but I couldn't figure out how to
fit it in there structurally. Plus, it needs more examples, output
samples, and a tutorial feel.

--Josh Berkus

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers