Re: BUG #16914: Regression test of the worker_spi fails if USE_MODULE_DB environment variable is set.

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: r(dot)zharkov(at)postgrespro(dot)ru, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16914: Regression test of the worker_spi fails if USE_MODULE_DB environment variable is set.
Date: 2021-03-04 21:13:56
Message-ID: 20210304211356.GA21621@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2021-Mar-04, Michael Paquier wrote:

> > test worker_spi ... FAILED 131652 ms
> > ============== shutting down postmaster
>
> Fun.

Eek.

> > Something like this fixes the problem:
>
> One problem with this solution is that this is not portable. Instead
> of generating dynamically the configuration file, here is funkier
> solution as we know that worker_spi would restart if the database it
> should connect to does not exist: let's use a completely different
> database name, not expected by any other modules. Then, this database
> gets created in worker_spi.sql, with a reconnection to it.

It's not that I *like* this solution, but let's say that I dislike it
less than the other one. If there are no other ideas, I +1 this one.

--
Álvaro Herrera 39°49'30"S 73°17'W

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-03-04 22:14:57 Re: BUG #16914: Regression test of the worker_spi fails if USE_MODULE_DB environment variable is set.
Previous Message Brandon Simmons 2021-03-04 15:14:35 Re: BUG #16912: pg_dump 11 does not respect --quote-all-identifiers within function bodies