Re: SQL workflow for crash testing correctness

Joseph Hammerman <[email protected]> Wed, 18 Sep 2019 12:44:55 -0400
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAFZjsjBm5H6VCwZJanKb12=trOjHFL2NKBNDX1qhk2RvDdLxMA@mail.gmail.com>
Good afternoon Luca,

Thanks for the response.

My goal is to maintain a write and read stream during a crash and then
generate a report showing that there are no lost or duplicated writes,
thereby provably keeping my HA-CP promises as I evolve my platform.

I would then like to have a crash test suite, that instruments partial and
full network partitions in addition to process and machine crashes.

I'll have a look at that projects code, thank you! Please let me know if
you have any other thoughts or links or anything of that nature.

Regards,
Joe Hammerman

On Wed, Sep 18, 2019 at 11:22 AM Luca Ferrari <[email protected]> wrote:

> On Wed, Sep 18, 2019 at 3:27 AM Joseph Hammerman
> <[email protected]> wrote:
> > Does anyone have thoughts on how to model this? My initial thoughts were
> to find the serialization tests in the Postgres project core.
>
> It's quite hard to suggest without knowing what you are trying to achieve.
> I would however look for an inspiration on the test suite for
> PostgreSQL-XC, if available.
>
> Hope it helps.
> Luca
>