pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Michael Paquier <michael@paquier.xyz>
Cc: r.zharkov@postgrespro.ru
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16914: Regression test of the worker_spi fails if USE_MODULE_DB environment variable is set.
Date: Thu, 4 Mar 2021 18:13:56 -0300
Message-ID: <20210304211356.GA21621@alvherre.pgsql> (raw)
In-Reply-To: <YEDVnLVgr27T3ivk@paquier.xyz>

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





view thread (8+ messages)  latest in thread

Message-ID: <20210304211356.GA21621@alvherre.pgsql>
Permalink:  ../20210304211356.GA21621@alvherre.pgsql/
Also on:    postgresql.org/message-id/20210304211356.GA21621@alvherre.pgsql

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: alvherre@alvh.no-ip.org, michael@paquier.xyz, r.zharkov@postgrespro.ru, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #16914: Regression test of the worker_spi fails if USE_MODULE_DB environment variable is set.
  In-Reply-To: <20210304211356.GA21621@alvherre.pgsql>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox