zalando / zalando/postgres-operator

Default postgres instances don't reject connections without ssl

Open
#2,975 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Go
Stars
5.2k
Forks
1.1k
Avg merge
2d 16h
Merged PRs (30d)
3

Description

The documentation states that by default non-SSL connections are rejected. That does not seem to be the case for me, since the pg_hba.conf has line 7 which matches before the rejection.

apiVersion: acid.zalan.do/v1
kind: postgresql
metadata:
  name: test-cluster
  namespace: test
spec:
  numberOfInstances: 1
  teamId: test
  volume:
    size: 2Gi
  postgresql:
    parameters: {}
    version: "17"

Connection:

k port-forward pod/test-cluster-0 5432:5432
psql "host=localhost user=postgres sslmode=disable"

Log Output:

2025-11-04 13:44:51 UTC [281]: [2-1] 690a0353.119 0 postgres postgres [unknown] ::1 LOG:  connection authenticated: identity="postgres" method=md5 (/home/postgres/pgdata/pgroot/data/pg_hba.conf:7)

Line 7 in Question:

# Do not edit this file manually!
# It will be overwritten by Patroni!
local   all             all                                   trust
hostssl all             +zalandos          127.0.0.1/32       pam
host    all             all                127.0.0.1/32       md5
hostssl all             +zalandos          ::1/128            pam
host    all             all                ::1/128            md5 # Line 7
local   replication     standby                               trust
hostssl replication     standby            all                md5
hostnossl all           all                all                reject
hostssl all             +zalandos          all                pam
hostssl all             all                all                md5
  • postgres-operator 1.14.0 on OKD 4.19

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by comparing the documented default SSL behavior with the generated pg_hba.conf shown in the report, focusing on rule ordering and the localhost entries. Reproduce the Kubernetes manifest and psql connection, then determine whether the operator configuration or documentation is incorrect; done means non-SSL connections are rejected as documented or the documentation accurately describes the behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
kubernetes, postgresql
Domain
databases, infrastructure
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.