Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries, should producers of soft ware based services such as ATMs be held liable for economic injuries suffered when their systems fail?, nisc wwwxxx, wwwxxx0cm, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry

Links

XODOX
Impressum

#1: Database syncronization

Posted on 2005-04-20 18:44:26 by Shadow

Hy all !

Is there any tool, middelware, or feature to syncronize 2 databases (With the
same schema, ofcourse)

I have an application that runs from 2 points. One of this points has a master
database and the other point neds to sync its data daily from the master.

Any suggestion ?

Thanks !

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Report this message

#2: Re: Database syncronization

Posted on 2005-04-20 19:00:57 by Steve Crawford

On Wednesday 20 April 2005 9:44 am, Shadow wrote:
> Hy all !
>
> Is there any tool, middelware, or feature to syncronize 2 databases
> (With the same schema, ofcourse)
>
> I have an application that runs from 2 points. One of this points
> has a master database and the other point neds to sync its data
> daily from the master.

There are several options depending on your needs.

If you just need a second machine updated daily then just do a
pg_dumpall from the master and restore it on the second machine (all
automated from cron).

Alternately, in 8.x you can copy the master's files to the second
machine and then just use the WAL files to keep the second machine
up-to-date. If you like this option check the backup section of the
documentation, especially section 22.3, to read about on-line backup
and recovery.

For near real-time replication you can use a replication solution like
slony-i.

All of the above assume that all modifications to the database are
done to the master and simply duplicated one way or another to a
slave.

There are also projects that act as connection-pooling and
load-balancing solutions that write all changes to multiple
databases. I believe dbbalancer is one but it is listed as "Alpha"
and the last update was in 2002.

Cheers,
Steve

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

Report this message

#3: Re: Database syncronization

Posted on 2005-04-20 19:08:57 by John DeSoi

On Apr 20, 2005, at 12:44 PM, Shadow wrote:

> Is there any tool, middelware, or feature to syncronize 2 databases
> (With the
> same schema, ofcourse)
>
> I have an application that runs from 2 points. One of this points has
> a master
> database and the other point neds to sync its data daily from the
> master.
>
> Any suggestion ?

A few options -

Free:
http://gborg.postgresql.org/project/slony1/projdisplay.php

Commercial:
http://www.commandprompt.com/products/mammothreplicator/



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Report this message

#4: Re: Database syncronization

Posted on 2005-04-20 20:12:25 by decibel

http://www.google.com/search?q=postgresql+replication

And http://gborg.postgresql.org/project/slony1/projdisplay.php, which is
missing for some reason...

On Wed, Apr 20, 2005 at 06:44:26PM +0200, Shadow wrote:
>
> Hy all !
>
> Is there any tool, middelware, or feature to syncronize 2 databases (With the
> same schema, ofcourse)
>
> I have an application that runs from 2 points. One of this points has a master
> database and the other point neds to sync its data daily from the master.
>
> Any suggestion ?
>
> Thanks !
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Report this message