BUG: postgresql.auto.conf location

Hello, team!

I’m not sure if this is a bug or not, but the behavior of the postgresql server somewhat confusing.

The postgresql server is started with following parameters:
/usr/lib/postgresql/9.5/bin/postgres -D /var/lib/postgresql/9.5/main -c config_file=/etc/postgresql/9.5/main/postgresql.conf
hba_file = '/etc/postgresql/9.5/main/pg_hba.conf'
ident_file = '/etc/postgresql/9.5/main/pg_ident.conf'

After that the following command is executed: ‘ALTER SYSTEM SET max_connections = xxx;’

File postgresql.auto.conf is be created at ‘data’ directory, although this is expected in the same directory as the main postgresql.conf file.

This is a confusing, because in case of backup/restore or pg_basebackup to a new server (or new slave server), auto.conf file also will be transferred and applied to a new server, which in some cases is not expected.

Alexandr Blinov
System Administrator
T: + 41 22 575 2554 | T: + 7 495 258 7088
Av Mon Repos 14 | 1005 Lausanne | Switzerland
1-ya Rybinskaya Street 3 | 107113 Moscow | Russia
www.mysky.com

National Winner for Switzerland 2017/2018 European Business Awards <https://www.businessawardseurope.com/otww/Switzerland>