From: | Prashanth Goriparthi <gprashanthkumar(at)gmail(dot)com> |
---|---|
To: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Changing listen_addresses |
Date: | 2013-07-23 17:02:23 |
Message-ID: | CA+Mf8bVEgi2O7pRxHqxBL7rFwQqrGuxNnHnwL=u+Kst5MASUJQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2013-07-23 19:34:45 | Re: Changing listen_addresses |
Previous Message | Birchall, Austen | 2013-07-23 16:55:34 | Re: Changing listen_addresses |