Data replication

[GP]

Hi all,

I am quite new in Postgresql and I am wondering if it supports data
replication.
If I understand correctly postgresql has only the "pg_dumpall" function
that makes a copy/backup of the database, and it does not support a
functionality for automatic data replcation in a backup database ???

If this is the case, the solution of writing a script that calls the
"pg_dumpall" every 5 minutes and export that file to another backup
database will work or the system will crash ?

Thanks in advance
George






---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Andrew Sullivan]

Post by GP
Hi all,
I am quite new in Postgresql and I am wondering if it supports data
replication.

Yes. There are several projects supporting it, some in contrib/ and
some on the gborg.postgresql.org site. My employer, Afilias uses
erserver today, and that is available from the gborg site. It's a
pain to administer, and there are a number of fairly significant
limitations, but it works. Note that I do not speak for my employer.

Afilias is also supporting a new project, Slony-I, also available
from the gborg site. IT'S NOT READY YET, but the work is progressing
quickly (thanks to my colleague Jan Wieck), and if you're just
starting a project which will go to production in 6 months' time or
more, I'd suggest starting with Slony right now. Don't use it in
production, yet, however. I think it's safe to say that it isn't
ready for that.

A