From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Tino Wildenhain" <tino(at)wildenhain(dot)de>, "Arnaud Lesauvage" <thewild(at)freesurf(dot)fr> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Best high availability solution ? |
Date: | 2006-05-31 11:24:34 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4013885CA@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tino
> Wildenhain
> Sent: 31 May 2006 12:14
> To: Arnaud Lesauvage
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Best high availability solution ?
>
> > Then with a script that would change my DNS so that
> > mypgserver.domain.tld (used in ODBC connection string)
> points to CNAME
> > mybackupserver.domain.tld instead of CNAME
> mymasterserver.domain.tld,
> > getting back to production ould be quite easy...?
>
> I guess the users would start over anyway. So easiest if you
> provide a copy of the app with that other connection and
> signal them if the first server dies to just close the first
> and start the backup-application.
Yes - the DNS method would work, but you might run into caching issues
requiring the users to reboot or do a 'ipconfig /flushdns' before they
see the change.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Arnaud Lesauvage | 2006-05-31 11:32:42 | Re: Best high availability solution ? |
Previous Message | Tino Wildenhain | 2006-05-31 11:13:43 | Re: Best high availability solution ? |