Re: Three Variations of postgresql.conf

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Three Variations of postgresql.conf
Дата
Msg-id CANu8FiygR5CdeqRTiE0YM+BQk6aK+qZyw2frH_FWV27J1exong@mail.gmail.com
обсуждение исходный текст
Ответ на Three Variations of postgresql.conf  (Michael Convey <smconvey@gmail.com>)
Ответы Re: Three Variations of postgresql.conf  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Ubuntu does not use the standard pg_ctl for postgreSQL. Instead, it uses pg_ctlcluster.
That in turn controls the different PostgreSQL clusters. When you do an install of a new cluster, pg_ctlcluster is smart enough to put postgresql.conf & pg_hba.conf into separate dirs.
So to be specific, /usr/lib/tmpfiles.d/postgresql.conf is just a tmp file that you can ingnore, /etc/postgresql/9.4/main/postgresql.conf is the original version for the 9.4 cluster and /var/lib/postgresql/9.4/main/postgresql.auto.conf is the actual, live version of the 9.4 cluster that you need to change to affect the 9.4 cluster. Likewise for the pg_hba.conf.

On Thu, Nov 12, 2015 at 10:46 AM, Michael Convey <smconvey@gmail.com> wrote:
In Ubuntu 14.10, there are three variations of the postgresql.conf configuration file, as follows: 

/var/lib/postgresql/9.4/main/postgresql.auto.conf
/usr/lib/tmpfiles.d/postgresql.conf
/etc/postgresql/9.4/main/postgresql.conf

What is the difference between these files and which is the correct one to change for modifying the configurations contained therein?



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Three Variations of postgresql.conf
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Three Variations of postgresql.conf