Re: Changing listen_addresses

Поиск
Список
Период
Сортировка
От Prashanth Goriparthi
Тема Re: Changing listen_addresses
Дата
Msg-id CA+Mf8bVEgi2O7pRxHqxBL7rFwQqrGuxNnHnwL=u+Kst5MASUJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Changing listen_addresses  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Список pgsql-novice
Дерево обсуждения
Birchall,

Check which config your server is using by running : select setting from pg_settings where name='config_file' and update listen_address value in that config. I bet you are updating wrong config.

Thanks,
Prashanth Goriparthi

Thanking you,
Prashanth Goriparthi



On Tue, Jul 23, 2013 at 10:55 AM, Birchall, Austen <austen.birchall@metoffice.gov.uk> wrote:
I just spotted that my server seems to have 2 postgresql.conf files installed

One at

/var/lib/pgsql/data/postgresql.conf

And another one at

/var/lib/pgsql/9.1/data/postgresql.conf


By convention which is the correct one to use?

Austen


9.1.9 on Red Hat 6 64 bit

Hi

I have set

 postgresql.conf:listen_addresses = '*'                  # what IP address(es) to listen on;

But even after a number of stops & restarts I still get

show listen_addresses;
 listen_addresses
------------------
 localhost
(1 row)

Any ideas why the change is not being auctioned?

Thanks

Austen

Austen Birchall
DBA
Met Office


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

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

Предыдущее
От: "Birchall, Austen"
Дата:
Сообщение: Re: Changing listen_addresses
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: Changing listen_addresses