Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2

From: Chris Travers <chris(dot)travers(at)adjust(dot)com>
To: Chris Travers <chris(dot)travers(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, ashutosh(dot)bapat(at)enterprisedb(dot)com
Subject: Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2
Date: 2018-10-03 08:03:03
Message-ID: CAN-RpxASS7kXi4c-+jhWVs=4vqy6Br_LJRrxoGsjgFCMnHWnvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 3, 2018 at 9:56 AM Chris Travers <chris(dot)travers(at)adjust(dot)com>
wrote:

>
>
> On Wed, Oct 3, 2018 at 9:41 AM Chris Travers <chris(dot)travers(at)gmail(dot)com>
> wrote:
>
>>
>> (errmsg("preparing foreign transactions
> (max_prepared_foreign_transactions > 0) requires maX_foreign_xact_resolvers
> > 0")));
>

Two more critical notes here which I think are small blockers.

The error message above references a config variable that does not exist.

The correct name of the config parameter is
max_foreign_transaction_resolvers

Setting that along with the following to 10 caused the tests to pass, but
again it fails on default configs:

max_prepared_foreign_transactions, max_prepared_transactions

>
>
>
> --
> Best Regards,
> Chris Travers
> Head of Database
>
> Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com
> Saarbrücker Straße 37a, 10405 Berlin
>
>

--
Best Regards,
Chris Travers
Head of Database

Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com
Saarbrücker Straße 37a, 10405 Berlin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Travers 2018-10-03 09:02:29 Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2
Previous Message Chris Travers 2018-10-03 07:56:36 Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2