<@U11MDJNGZ> do you know why postgresql on a prima...
# puppet-enterprise
b
@csharpsteen do you know why postgresql on a primary is listening on *, when I've no replica, no standalone puppetdb. no compilers? That seems unnecessary / like a security issue to me. Tested on 2025.6.0 EL9
c
You're right that nothing external needs to connect to Postgres when a Standard install without DR is used (no compilers, no replica). One thing I can think of is that changing Postgres listen address from
localhost
->
*
likely requires a full restart in order to re-bind the port. That is pretty disruptive, so having Postgres listen on
*
by default makes it easy to build out a Standard install into a Large or XL without disrupting in-flight operations. The default configuration does have VERY tight security for what communication is accepted on port 5432. Incoming connections MUST present a certificate signed by the Puppet CA that is also listed in the Postgres
pg_ident.conf
as granting access to the database role. Sure, there is a theoretical risk of some 0-day exploit that bypasses auth. Blocking port 5432 with a firewall rule would mitigate that.
b
Yeah it's quite strict, I just wasn't sure if I missed something that requires the public PostgreSQL