From: | bubba postgres <bubba(dot)postgres(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump on Hot standby : clarification on how to |
Date: | 2011-05-12 18:26:38 |
Message-ID: | BANLkTi=8RVtvD2ezKYoq5F2Mwf_GnuJbQQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I would just like to get some clarification from the list on how to do a
pg_dump on the slave in the face of "canceling statement due to conflict
with recovery".
The following links seem to indicate that If I start an idle transaction on
the master I should be able to do the pg_dump, but I tried this in psql on
the master "start transaction", and was still unable to do a pg_dump on the
slave at the same time.
Is there something special about using dblink that would make this all work?
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 *standby* and end them after *pg_dump* (or whatever) is finished.
From | Date | Subject | |
---|---|---|---|
Next Message | raghu ram | 2011-05-12 18:36:56 | Re: Postgredac Dump |
Previous Message | James B. Byrne | 2011-05-12 17:14:07 | Re: How to handle bogus nulls from ActiveRecord |