Postgres Pro
Downloads
Home   >   mailing lists

Re: grant connect to all databases - Mailing list pgsql-general

From Matt Zagrabelny
Subject Re: grant connect to all databases
Date
Msg-id CAOLfK3Vnjoddno+Maj8bXoUVZWLAOgCwmotx02yyb92CMZ7zog@mail.gmail.com
Whole thread Raw
In response to Re: grant connect to all databases  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view


On Sat, Oct 5, 2024 at 5:43 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 10/5/24 15:04, Matt Zagrabelny wrote:

> psql (15.8 (Debian 15.8-0+deb12u1))
>
>
>     Where did you install it from or where are you running it?
>
>
> Installed from Debian repos via apt via puppet.
>
> Still digging...

To me it looks like something is doing:

REVOKE CONNECT
     ON DATABASE <some_db>
     FROM PUBLIC;


I think we have a winner.

When puppet creates the database, it revokes connect:


I'll have to ponder a solution. :(

Thanks for all the help (David, Adrian, and Tom)! I very much appreciate you taking time to give me some guidance and pointers.

Cheers!

-m

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: grant connect to all databases
Next
From: KK CHN
Date:
Subject: Re: CLOSE_WAIT pileup and Application Timeout