| From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | 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-21 16:20:46 |
| Message-ID: | 1158855646.3874.15.camel@coppola.muc.ecircle.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > Cons:
> - No reliability. On slow days, WAL logs could take a long time to
> rotate, so small but important transactions might not be replicated
> for a long time.
That's gone with 8.2, it will be possible to stream the last
modifications, or force a WAL recycle periodically, whatever fits you
better. There is some new infrastructure which allows these things,
although I didn't have the time to play with them.
The big improvement would be indeed to have the infrastructure to start
up a standby by simply pointing it to the master server, no other setup
needed. Implement that, make it reliable, and any beginner to postgres
will be able to easily set up a WAL shipping based standby. Right now
you still have to do some complicated scripting to make it work (no idea
how much 8.2 will help here, didn't try yet).
Cheers,
Csaba.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2006-09-21 16:44:28 | Re: Replication and PITR |
| Previous Message | Philip Hallstrom | 2006-09-21 16:11:33 | Re: postgresql rising |