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
