On Sun, Feb 27, 2011 at 1:57 PM, Sean Laurent wrote:
> Right. I read all of that. I guess I just assumed it was possible to create
> a snapshot on the standby so that a longer running on the standby could
> complete. In particular, I was really hoping to run database dumps against
> the standby, n
On 28/02/11 03:57, Sean Laurent wrote:
> Right. I read all of that. I guess I just assumed it was possible to create
> a snapshot on the standby so that a longer running on the standby could
> complete. In particular, I was really hoping to run database dumps against
> the standby, not the master.
On Sonntag, 27. Februar 2011, Sean Laurent wrote:
> In particular, I was really hoping to
> run database dumps against the standby, not the master.
One solution is to begin idle transactions on the master by using
e.g. dblink from the standby to the master before you start pg_dump
on the standb
On Sunday, February 27, 2011 11:57:35 am Sean Laurent wrote:
> On Sun, Feb 27, 2011 at 1:04 PM, Jens Wilke wrote:
> > On Sonntag, 27. Februar 2011, Sean Laurent wrote:
> > > Unfortunately, most queries against the hot standby fail. Worse
> >
> > > yet, pg_dump fails:
> > ...
> >
> > > I'm not en
On Sun, Feb 27, 2011 at 1:04 PM, Jens Wilke wrote:
> 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
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 grea
I have a hot-standby instance setup using Postgres 9.0.1 with streaming
replication against a 9.0.1 master. On the master, I have the following set
in the postgresql.conf:
checkpoint_segments = 3
checkpoint_timeout = 1min
checkpoint_completion_target = 0.5
max_wal_senders = 3
wal_sender_delay = 20
