Arnaud Lesauvage schrieb:
...
>
> I think you're right.
> Is there a simple replication solution for windows then ? Or will I have
> to stop the master postgresql at night to pgdump and pgrestore on the
> backup server ?
pg_dump does not require you to stop the master database anyway.
(in fact it cannot even dump a stopped database :-)
> If I have a synchronized backup server (even if it synchronizes once or
> twice a day, this might be OK), I could just write a simple script that
> would change the host file of the clients to have the postgresql's name
> to point to the backup IP...
I think you can use PITR for this use-case:
http://www.postgresql.org/docs/current/static/backup-online.html
Regards
Tino
