Re: FATAL: no such database

On Feb 21, 2022, at 7:54 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> [ please keep the list cc'd ]
>
> BeeRich Lists <bee(dot)lists(at)gmail(dot)com> writes:
>>> On Feb 21, 2022, at 3:43 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> Well, that's just odd. Do you have any nondefault extensions loaded into
>>> the database?
>
>> I have installed the following (what I remember, just a handful). I’m unclear which ones :
>
>> cube | 1.4 | public | data type for multidimensional cubes
>> earthdistance | 1.1 | public | calculate great-circle distances on the surface of the Earth
>> hstore | 1.6 | public | data type for storing sets of (key, value) pairs
>> pg_trgm | 1.4 | public | text similarity measurement and index searching based on trigrams
>> plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
>> uuid-ossp | 1.1 | public | generate universally unique identifiers (UUIDs)
>
> None of those contain that string, either.
>
> In any case, a generic extension wouldn't cause this problem,
> it'd have to be something that adds code to session start.
> I'm pretty sure that could only be modules that are listed
> in shared_preload_libraries or session_preload_libraries;
> have you got entries in either one?
>
> [ thinks for a bit... ] Another possibility perhaps is that
> you've got something in front of the server, like a connection
> pooler, and it's not coping.

Oops, sorry about that.

Yes, just tested my pgbouncer (a pooler). That was it. Tested both ports and pgbouncer didn’t respond accordingly.

Thank you!

Cheers, Bee