Q: pg_hba.conf separate database names file format

From: Albrecht Dreß <albrecht(dot)dress(at)netcologne(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Q: pg_hba.conf separate database names file format
Date: 2022-11-08 13:16:03
Message-ID: NXFJVAUX.C35JFJNY.4IYT4D2Y@I56PTRRI.6PUFY6O7.54SL26VD
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

according to the docs, the database specification in the pg_hba.conf file can be read from a separate file (<https://www.postgresql.org/docs/current/auth-pg-hba-conf.html>: “A separate file containing database names can be specified by preceding the file name with @.”)

However, I could not find a specification of the format for this file… It appears as if simply giving each database name on a separate line does the job. Is this correct? May the file contain comments (i.e. lines starting with “#”) or empty lines? May the file be specified including a path (e.g. “@/some/path/databases”)?

IMHO, it might be helpful if this information would be added to the docs.

Thanks, Albrecht.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Imre Samu 2022-11-08 14:05:34 Re: Information to CVE-2022-42889
Previous Message Ron 2022-11-08 13:02:09 Re: Feature suggestions for backup and replication