Re: Changing listen_addresses

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(dot)birchall(at)metoffice(dot)gov(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>