Re: Best high availability solution ?

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