Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing listen_addresses - Mailing list pgsql-novice

From Birchall, Austen
Subject Re: Changing listen_addresses
Date
Msg-id 4E154FB60786D74BB4DFDC97BF991CAC071F2F@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Whole thread Raw
In response to Re: pg_ctl stop failure  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Responses Re: Changing listen_addresses  (Prashanth Goriparthi <gprashanthkumar@gmail.com>)
Re: Changing listen_addresses  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Birchall, Austen"
Date:
Subject: Changing listen_addresses
Next
From: Prashanth Goriparthi
Date:
Subject: Re: Changing listen_addresses