From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Arnaud Lesauvage" <thewild(at)freesurf(dot)fr> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Best high availability solution ? |
Date: | 2006-05-31 10:46:05 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4013885C0@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: Arnaud Lesauvage [mailto:thewild(at)freesurf(dot)fr]
> Sent: 31 May 2006 11:27
> To: Dave Page
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Best high availability solution ?
>
> Dave Page a écrit :
> > Slony-I only exists for Windows in a not-even-beta state at
> the moment,
> > so even if you get things up and running using a virtual IP
> solution you
> > will be hand-holding Slony until it gets properly released.
>
> OK, I thought it was in production stage.
The code is written, and is good as far as we are aware, but has not been through a beta/release cycle yet.
> 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.
> 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...
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.
Regards, Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2006-05-31 10:50:32 | Re: Best high availability solution ? |
Previous Message | Tino Wildenhain | 2006-05-31 10:34:11 | Re: Best high availability solution ? |