On Sun, 2006-03-26 at 22:22, calendarw wrote: > Oh, > > Unlucky for that my servers are both windows 2003, so I think I need > to find another way to sync two database.
If you just need a mostly up to date copy of one database on another machine, you can do something like this: dropdb -h destination dbname createdb -h destination dbname pg_dump -h source dbname | psql -h destination dbname to get a fairly up to date one. And I think PITR works in windows, but I haven't tried it. In fact, I haven't used Windows in a very long time now. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
