From: Tom Lane <tgl@sss.pgh.pa.us>
To: BeeRich Lists <bee.lists@gmail.com>
cc: pgsql-novice@lists.postgresql.org
Subject: Re: FATAL: no such database
In-reply-to: <710F9E09-25AF-49A6-AF2A-96FC74ADE7D8@gmail.com>
References: <AB678941-ED2D-49BF-9EF5-919A2D8538F3@gmail.com>
 <582711.1645476238@sss.pgh.pa.us>
 <710F9E09-25AF-49A6-AF2A-96FC74ADE7D8@gmail.com>
Comments: In-reply-to BeeRich Lists <bee.lists@gmail.com>
	message dated "Mon, 21 Feb 2022 19:36:09 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <604607.1645491276.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 21 Feb 2022 19:54:36 -0500
Message-ID: <604608.1645491276@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/604608.1645491276%40sss.pgh.pa.us>
Precedence: bulk

[ please keep the list cc'd ]

BeeRich Lists <bee.lists@gmail.com> writes:
>> On Feb 21, 2022, at 3:43 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Well, that's just odd.  Do you have any nondefault extensions loaded in=
to
>> the database?

> I have installed the following (what I remember, just a handful).  I=E2=80=
=99m unclear which ones :

>  cube          | 1.4     | public     | data type for multidimensional c=
ubes
>  earthdistance | 1.1     | public     | calculate great-circle distances=
 on the surface of the Earth
>  hstore        | 1.6     | public     | data type for storing sets of (k=
ey, 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 iden=
tifiers (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.

			regards, tom lane