| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, Bo Lorentsen <bl(at)netgroup(dot)dk>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Replication and PITR |
| Date: | 2006-09-26 09:10:11 |
| Message-ID: | 20060926091011.GA19913@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Sep 26, 2006 at 11:00:56AM +0200, Csaba Nagy wrote:
> Of course there might be other problems too.
Another thing would be that the read-only transaction still needs a
snapshot, and whatever transaction ID it uses will have been used by
the server also.
I think the visibility issue may be solvable as long as the transaction
ID on the slave doesn't pass the VACUUM horizon of the server. But it
would require careful studying of the WAL write order to be confident
it would actually work.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gurjeet Singh | 2006-09-26 10:12:55 | Re: in failed sql transaction |
| Previous Message | 林黛玉 | 2006-09-26 09:01:49 | cannt setup postgresql database for my opennms |