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.