From: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Best high availability solution ? |
Date: | 2006-05-31 10:53:21 |
Message-ID: | 447D75A1.4030902@freesurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dave Page a écrit :
> The code is written, and is good as far as we are aware, but has not been through a beta/release cycle yet.
OK, that's already pretty good then.
Are there binary releases available ?
>> 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 ?
>
> You don't need to stop the master server to pg_dump (in fact, it won't work if you do). On the slave, you can just drop the DBs and pg_restore them.
> PITR is another solution you might consider.
It looks quite harder to script though... But I'll consider it as
a better solution.
> Might be better if the users know they are being switched over - that way they will know to check for lost transactions etc. If you're using an ODBC app, consider using a separate DSN for the live and backup servers - similar solutions would apply to other interfaces of course.
There are no critical transactions here.
If the DB server fails and users are switched over to a backup
server with data of the day before, it is just fine.
Losing 1/2 of work is OK, but not working for 4 days is not.
So I might just write a script so that the person in charge when I
am away can run it and alert everyone.
--
Arnaud
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-05-31 11:00:40 | Re: Best high availability solution ? |
Previous Message | Tino Wildenhain | 2006-05-31 10:50:32 | Re: Best high availability solution ? |