BUG: postgresql.auto.conf location
От
Alexandr Blinov
Тема
BUG: postgresql.auto.conf location
Дата
Msg-id
6B536098-5BCE-4188-8348-8A11C293A29C@mysky.com
Список
Дерево обсуждения
BUG: postgresql.auto.conf location Alexandr Blinov <alexandr.blinov@mysky.com>
Re: BUG: postgresql.auto.conf location Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG: postgresql.auto.conf location "David G. Johnston" <david.g.johnston@gmail.com>
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
В списке pgsql-bugs по дате отправления
От: Michael Paquier
Дата:
