Re: standbycheck was:(Re: [HACKERS] testing hot standby - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: standbycheck was:(Re: [HACKERS] testing hot standby
Date
Msg-id q2v3073cc9b1004260045k6eb9deecm5fcd93b843501b55@mail.gmail.com
Whole thread Raw
In response to Re: standbycheck was:(Re: [HACKERS] testing hot standby  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: standbycheck was:(Re: [HACKERS] testing hot standby  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Mon, Apr 26, 2010 at 2:32 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
>
> How many of the tests in the regular regression suite do anything useful
> when run against a standby server? They all have to set up a bunch of
> objects before they run queries, so you just get a lot of errors
> complaining that you can't do X in standby mode, followed by errors
> about missing objects. That doesn't sound very useful.
>
>

granted. what i'm looking for is a way of continually see that the
standby will return consistent values and yes, i want to be sure that
we disallow everything that we need to...

maybe just a new set of tests? maybe i just should make the hs_* tests
use regression's database tables intead of the ones it is using?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: testing HS/SR - 1 vs 2 performance
Next
From: Dimitri Fontaine
Date:
Subject: Re: recovery_connections cannot start