pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedData replication
2+ messages / 2 participants
[nested] [flat]
* Data replication
@ 2004-04-20 08:08 GP <pagomen@csd.uoc.gr>
2004-04-20 11:35 ` Re: Data replication Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 2+ messages in thread
From: GP @ 2004-04-20 08:08 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Data replication
2004-04-20 08:08 Data replication GP <pagomen@csd.uoc.gr>
@ 2004-04-20 11:35 ` Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Andrew Sullivan @ 2004-04-20 11:35 UTC (permalink / raw)
To: pgsql-admin
On Tue, Apr 20, 2004 at 11:08:12AM +0300, GP wrote:
> 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
--
Andrew Sullivan | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-20 11:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-20 08:08 Data replication GP <pagomen@csd.uoc.gr>
2004-04-20 11:35 ` Andrew Sullivan <ajs@crankycanuck.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox