From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
---|---|
To: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
Cc: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Best high availability solution ? |
Date: | 2006-05-31 10:34:11 |
Message-ID: | 447D7123.8000600@wildenhain.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-05-31 10:46:05 | Re: Best high availability solution ? |
Previous Message | Martijn van Oosterhout | 2006-05-31 10:29:21 | Re: UTF-8 context of BYTEA datatype?? |