saltstack-formulas/postgres-formula

[QUESTION] Extra configuration files

tiyab opened this issue · 0 comments

tiyab commented

Hi,
The way I am using PostgreSQL is, once installed, I do not modify the file /etc/postgresql/[VERSION]/main/postgresql.conf.
I prefer to create extra configuration files that I put in /etc/postgresql/9.6/[VERSION]/conf.d/ since files in *.conf directory are automatically loaded.
That way I have:

  • ../conf.d/general.conf in which I set common parameters like listen_addresses = '*' and other stuffs.
  • ../conf.d/replication.conf if I have to set a replication

Other files that could be managed are: .psqlrc, .pgpass or pg_ident.

For the moment, I am managing everything through salt/postgres/init.sls with some file.managed. But I am under the impression of missing something by doing it this way.

So my question is would be a good idea to manage extra configuration files with this formula?