Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.40.0.1.81\))
Subject: Re: FATAL: no such database
From: BeeRich Lists <bee.lists@gmail.com>
In-Reply-To: <604608.1645491276@sss.pgh.pa.us>
Date: Mon, 21 Feb 2022 21:30:29 -0500
Cc: pgsql-novice@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <97369C8B-E6DE-42D1-9ABF-65036CADA04F@gmail.com>
References: <AB678941-ED2D-49BF-9EF5-919A2D8538F3@gmail.com>
 <582711.1645476238@sss.pgh.pa.us>
 <710F9E09-25AF-49A6-AF2A-96FC74ADE7D8@gmail.com>
 <604608.1645491276@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/97369C8B-E6DE-42D1-9ABF-65036CADA04F%40gmail.com>
Precedence: bulk

On Feb 21, 2022, at 7:54 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> [ please keep the list cc'd ]
>=20
> 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 =
into
>>> the database?
>=20
>> I have installed the following (what I remember, just a handful).  =
I=E2=80=99m unclear which ones :
>=20
>> 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)
>=20
> None of those contain that string, either.
>=20
> 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?
>=20
> [ 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.=20

Yes, just tested my pgbouncer (a pooler).  That was it.  Tested both =
ports and pgbouncer didn=E2=80=99t respond accordingly. =20

Thank you!


Cheers, Bee