On Sonntag, 27. Februar 2011, Sean Laurent wrote: > Unfortunately, most queries against the hot standby fail. Worse > yet, pg_dump fails: ... > I'm not entirely certain I understand why I'm seeing this. Nor do > I understand how to fix or work around this. Any advice or > suggestions would be greatly appreciated.
Long running queries on the standby are a bit tricky, because they might need to see row versions that are already removed on the master. It's well documented: http://www.postgresql.org/docs/9.0/static/hot-standby.html HTH, Jens -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
