From: | sdfasdf asdfasdf <sofiamay(at)mail(dot)ru> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgreSQL(dot)org |
Subject: | Re[4]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP |
Date: | 2014-04-25 20:27:31 |
Message-ID: | 1398457651.686725084@f87.i.mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I am not stupid. I start and stop postresql manually, not as sevice.
In Console:
**********************************
psql -U postgres
show config_file;
output:
C:/Postgre/postgresql.conf
**********************************
in file: listen_addresses = '127.0.0.1'
File works fine, but PostreSQL binds to all IP.
Parameter [i] in pg_ctl cmd line is i[mmediate] and does not affect for IP adress.
It is a bug.
Fri, 25 Apr 2014 16:10:10 -0400 от Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> =?UTF-8?B?c2RmYXNkZiBhc2RmYXNkZg==?= <sofiamay(at)mail(dot)ru> writes:
> > In Console:
> > **********************************
> > psql -U postgres
> > show listen_addresses;
>
> > output:
> > listen_addresses
> > ------------------
> > *
> > (1 User)
> > **********************************
>
> Well, if it's saying that, then it's not a bug that it is in fact
> binding to all addresses.
>
> I suspect Stephen was right that you forgot to restart the postmaster
> after changing the configuration file. (pg_ctl reload is *not* enough for
> changing this parameter.)
>
> Another theory is that the file you edited isn't the one the postmaster
> is looking at. ("show config_file" would help diagnose this.)
>
> Another theory is that the config file setting is being overridden by
> some higher-priority setting, such as "-i" on the postmaster command
> line. (Looking at the source for listen_addresses in
> "select * from pg_settings" would help diagnose this case.)
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Evgen Bodunov | 2014-04-25 20:55:53 | Re: BUG #10141: Server fails to send query result. |
Previous Message | Tom Lane | 2014-04-25 20:10:10 | Re: Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP |