On Wed, 2008-12-10 at 14:23 +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
> I am using pg 8.3 and configured warm standby server. It is working
> well, but my db is relative big ( ~ 40 GB).
>
> Is it possible to stop running "Warm standby server" and when it
> starts again to continue executing WA
Hi,
I am using pg 8.3 and configured warm standby server. It is working
well, but my db is relative big ( ~ 40 GB).
Is it possible to stop running ?"Warm standby server" and? when it
starts again to continue executing WALs from the stop moment.
I'm using following command to stop the ser
Scott & Montaseri,
Montaseri wrote:
While I am not an expert on WAL, but again I question the merits of
such sophisticated HA configuration. Of course there are use cases for
such configs, but I am only advocating best price performance kind of
mentality
As WAL writes the journals all the wa
On Thu, 2008-06-26 at 13:01 -0500, Scott Whitney wrote:
> A 2nd question: Is it possible to have 2 standby servers with a single
> master duplicating to standby1 (at my coloc), and standby2 (at my office)?
> Assume no auto-failover.
Yes, that works too.
--
Simon Riggs www.2ndQuadran
1:21 PM
To: Scott Whitney
Cc: Simon Riggs; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Warm standby server
While I am not an expert on WAL, but again I question the merits of such
sophisticated HA configuration. Of course there are use cases for such
configs, but I am only advocating best price p
itney; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Warm standby server
>
> I am not so sure of this arrangement's mertis
>
> From HA (High Availability) point of view, the host/server is a single
> point
> of failure which will bring your entire infrastructure down if
andby2 (at my office)?
Assume no auto-failover.
-Original Message-
From: Montaseri [mailto:[EMAIL PROTECTED]
Sent: Jun 26, 2008 12:51 PM
To: Simon Riggs
Cc: Scott Whitney; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Warm standby server
I am not so sure of this arrangement's m
I am not so sure of this arrangement's mertis
>From HA (High Availability) point of view, the host/server is a single point
of failure which will bring your entire infrastructure down if any of the
server hardware components fail.
>From Performance point of view, you have increased the load on yo
On Thu, 2008-06-26 at 10:19 -0500, Scott Whitney wrote:
> I've got 3 different database servers (db01, db02 and db03).
>
> I would like to have a WAL standby server that replays logs for all 3 in
> case one goes down, so I can promote that particular server.
>
> Can I do this by installing 3 sep
I've got 3 different database servers (db01, db02 and db03).
I would like to have a WAL standby server that replays logs for all 3 in
case one goes down, so I can promote that particular server.
Can I do this by installing 3 separate postmasters on this machine?
Obviously, if 2 went down at the s
Hi there,
A bit of background information:
I am running Postgres 8.2.4 on Solaris 10 in a warm standby configuration.
My archive command scp's WAL logs from the live server to the standby
server. The standby server runs in a recovery mode waiting for the WAL logs
and processing them as they b
11 matches
Mail list logo
