pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Data replication
2+ messages / 2 participants
[nested] [flat]

* Data replication
@ 2004-04-20 08:08  GP <pagomen@csd.uoc.gr>
  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 11:35  Andrew Sullivan <ajs@crankycanuck.ca>
  parent: GP <pagomen@csd.uoc.gr>
  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