Re: warm standby resume and take online problems

On Wed, 4 Nov 2009, Greg Smith wrote:

> On Wed, 4 Nov 2009, Michal Bicz wrote:
>
>> Now it is saying constantly in log :
>> 2009-11-04 04:57:39 PST : ERROR:  XX000: xlog flush request 2FB/28CE63A8 is
>> not satisfied --- flushed only to 2FB/8FFEA60
>> 2009-11-04 04:57:39 PST : CONTEXT:  writing block 874937 of relation
>> 1663/20863/21548
>> 2009-11-04 04:57:39 PST : LOCATION:  XLogFlush, xlog.c:1865
>
> I think you can run into this if disk space on the xlog drive fills up, which
> is easy to do with complicated WAL shipping setups if you're not careful.
> You might want to double-check that, and check for general disk I/O errors
> too.

Looks like Michal's response didn't go on-list, for anyone wandering what
the resolution was he says:

"Thanks but this is apparently is neither badblock nor space limits.
I recreated scenario and apparently warm standby server is set to be
respawned every time it is seen stopped.. That caused data to become
corrupted."

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
>From pgsql-general-owner(at)postgresql(dot)org Fri Nov 6 17:22:30 2009
Received: from maia.hub.org (unknown [200.46.204.183])
by mail.postgresql.org (Postfix) with ESMTP id 49415632F13
for <pgsql-general-postgresql(dot)org(at)mail(dot)postgresql(dot)org>; Fri, 6 Nov 2009 17:22:30 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
with ESMTP id 95194-05
for <pgsql-general-postgresql(dot)org(at)mail(dot)postgresql(dot)org>;
Fri, 6 Nov 2009 21:22:22 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-yx0-f181.google.com (mail-yx0-f181.google.com [209.85.210.181])
by mail.postgresql.org (Postfix) with ESMTP id 6A804632DAF
for <pgsql-general(at)postgresql(dot)org>; Fri, 6 Nov 2009 17:22:22 -0400 (AST)
Received: by yxe11 with SMTP id 11so1221089yxe.15
for <pgsql-general(at)postgresql(dot)org>; Fri, 06 Nov 2009 13:22:21 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:mime-version:received:date:message-id:subject
:from:to:cc:content-type;
bh=0/bMGoTQyzQyS+wpUKkKcud01jHIr3zJpDBpnRt3jiA=;
b=bMTAnbuetIt4/qoDmbvV/TdkY18T2W/XwGzI+dwbl7t3TNb3OzgClZ0mjuzIvlzcyb
dOAwHVPtBm4v6I+zfAaXUE//u6HbhbfVP/9BjJiAhjVs7oDiDnzxCLUn2o8BG3FKEGq+
J9hjNiS5i3J+yQuYV5xJCKVvPmffxtKoAOt8s=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=mime-version:date:message-id:subject:from:to:cc:content-type;
b=O9rUVsj0eIRuwDh5CggRZtr9zIBK3uZX/sKegWVRI76a9Mh05Yn9NKFv/dHM7stozn
5KV2OaW2ZP+Q9Sn1oaxpknkrAAtKjlHv5BqYyHEMSA5U0vj5809O6mK78PMnzL/s/J5A
/ABOGYZfq4j1DPVao4Fph5JVH36dGVLTbZ5vI=
MIME-Version: 1.0
Received: by 10.90.242.1 with SMTP id p1mr9465108agh.105.1257542538949; Fri,
06 Nov 2009 13:22:18 -0800 (PST)
Date: Fri, 6 Nov 2009 16:22:18 -0500
Message-ID: <fa2ac0580911061322i30f59c62xf45eb6a32da6ff3f(at)mail(dot)gmail(dot)com>
Subject: How do I include PostGIS geofunctions to a new database after I have
already installed PostGIS.
From: John Mitchell <mitchelljj98(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: John Mitchell <mitchelljj98(at)gmail(dot)com>
Content-Type: multipart/alternative; boundary=001636284f2852f5800477ba70a0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level:
X-Archive-Number: 200911/236
X-Sequence-Number: 155165

--001636284f2852f5800477ba70a0
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I have PostgreSQL 8.4 and I have a database which was created when PostGIS
was installed which has the geofunctions within it.

When I try to create a new database it does not include these geofunctions.

How do I include PostGIS geofunctions to a new database after I have already
installed PostGIS.

Thanks,

John

--
John J. Mitchell

--001636284f2852f5800477ba70a0
Content-Type: text/html; charset=ISO-8859-1

Hi,<br><br>I have PostgreSQL 8.4 and I have a database which was created when PostGIS was installed which has the geofunctions within it.<br><br>When I try to create a new database it does not include these geofunctions.<br>
<br>How do I include PostGIS geofunctions to a new database after I have already installed PostGIS.<br><br>Thanks,<br><br>John<br clear="all"><br>-- <br>John J. Mitchell<br>

--001636284f2852f5800477ba70a0--