Robert Haas wrote:
> On Tue, Apr 6, 2010 at 3:09 AM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>>> * Add the GUC parameter to specify the maximum number of log file segments held in pg_xlog directory to send to
thestandby server. Which is useful to avoid disk full in the primary.
>> Not only to avoid disk full in primary but also to make it feasible to
>> use streaming replication without archiving. It's a small change, we
>> should do it.
>
> Do we have a working patch?
No.
>>> * Redefine smart shutdown in standby mode?
>> Drop. Too big a change at this point.
>
> We have a working patch for this - I want to commit it. I don't think
> it's a big change, and the current behavior is extremely pathological.
Oh, ok. I didn't look at the latest patch, if it looks good to you, fine
with me.
>>> * If standby_mode is enabled, and neither primary_conninfo nor restore_command are set, the standby would get
stuck.
>> It's not really stuck, it will replay any WAL files you drop into
>> pg_xlog. I concur with Robert Haas though that it shouldn't print the
>> message to the log every few seconds. It should print a message the
>> first time it hits the end of WAL, but subsequent messages should be
>> suppressed until some progress has been made.
>
> Any idea how to implement this?
I'll take a look. It shouldn't be too hard.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com