On Sat, Oct 5, 2024 at 5:43 PM Adrian Klaver <adrian.kla...@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: https://github.com/puppetlabs/puppetlabs-postgresql/blob/main/manifests/server/database.pp#L55-L80 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
