Re: HotStandby vs. flatfile updates - Mailing list pgsql-hackers

From Gianni Ciolli
Subject Re: HotStandby vs. flatfile updates
Date
Msg-id 20090211184802.GA7130@fune
Whole thread Raw
In response to HotStandby vs. flatfile updates  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: HotStandby vs. flatfile updates  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Hi Bernd,

On Wed, Feb 11, 2009 at 03:49:24PM +0100, Bernd Helmle wrote:
> I'm currently facing with a strange behavior during HotStandby Testing.  
> That's what i'm actually doing:

it seems that this was a known bug ("snapshot bug"), which as noted in
 http://wiki.postgresql.org/wiki/Hot_Standby#Resolved_Items.2FIssues

was fixed in version 9h. We actually checked that this particular bug
had been fixed, using the test whose "summary" you can find below.

Probably you are running an old version: it's not your fault, since in
the same page I can read that 9g is the last published version (I know
that Simon is having some difficulties with git).

Thank you for testing,
Dr. Gianni Ciolli - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gianni.ciolli@2ndquadrant.it | www.2ndquadrant.it

---8<------8<------8<------8<------8<------8<------8<------8<------8<---

STANDBY:

try to connect to database "foo" (fails)

PRIMARY:

create database foo

STANDBY:

wait for propagation, then connect to database foo, and issue a simple
query;

PRIMARY;

drop database foo

STANDBY:

wait for propagation, then try connect to database foo (fails)



pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: GIN fast insert
Next
From: "BogDan Vatra"
Date:
Subject: Re: SE-PostgreSQL and row level security