| 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: | Whole Thread | Raw Message | 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?? |