On Mon, Jan 23, 2012 at 8:05 PM, Gary Webster wrote:
> Thanks for the informative replies.
>
> So, is Hot Standby the recommended way to do HA?
> My application does not need to be able to do queries on the standby.
Streaming replication is the recommended way to do HA, which is roughly "yes".
Hello.
Thanks for the informative replies.
So, is Hot Standby the recommended way to do HA?
My application does not need to be able to do queries on the standby.
On Mon, Jan 23, 2012 at 9:53 AM, Simon Riggs wrote:
> On Mon, Jan 23, 2012 at 2:48 PM, Gary Webster wrote:
>
> > I am configuring w
On Mon, Jan 23, 2012 at 10:21 AM, Andreas Hasenack wrote:
> On Fri, Jan 20, 2012 at 16:45, Nicholson, Brad (Toronto, ON, CA)
> wrote:
>> In the past I've used Slony to upgrade much larger database clusters than
>> yours with minimal down time (I'm talking seconds for the actual master
>> switch
On Fri, Jan 20, 2012 at 16:45, Nicholson, Brad (Toronto, ON, CA)
wrote:
> In the past I've used Slony to upgrade much larger database clusters than
> yours with minimal down time (I'm talking seconds for the actual master
> switch). You set up a new replica on the new version and then move the
On Mon, Jan 23, 2012 at 2:48 PM, Gary Webster wrote:
> I am configuring warm-standby as documented here:
> http://www.postgresql.org/docs/8.4/interactive/warm-standby.html
>
> I am using "pg_standby", & may have it working corrrectly, but am not sure.
>
> 1) The standby database never 'starts',
Hi,
On Mon, 2012-01-23 at 09:48 -0500, Gary Webster wrote:
> 1) The standby database never 'starts', right?
> (/etc/init.d/postgresql-8.4 start" times out; I can't connect to the
> db to see if tables are correct).
>
> 2) Because of #1, I suppose I can't do a pg_dump on the standby db?
Both a
Hello.
I am configuring warm-standby as documented here:
http://www.postgresql.org/docs/8.4/interactive/warm-standby.html
I am using "pg_standby", & may have it working corrrectly, but am not sure.
1) The standby database never 'starts', right? (/etc/init.d/postgresql-8.4
start" times out; I ca
Hi,
for all who may encounter this error message on windows 2008R2 using the one
click installer:
DO NOT create a test machine named "Postgres" (the same as the service account
user name) and try to install Postgres Server on it after that, cause you will
get the above mentioned error messag
> -Original Message-
> From: francis picabia [mailto:fpica...@gmail.com]
> Sent: Friday, January 20, 2012 3:39 PM
> To: Nicholson, Brad (Toronto, ON, CA)
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Best practise for upgrade of 24GB+ database
> > In the past I've used Slony to up
