Re: Postgres 9.6.1 accepts connections from not allowed Ip addresses

From: Greg Stark <stark(at)mit(dot)edu>
To: Jan Ogrodowczyk <Jan(dot)Ogrodowczyk(at)qlik(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Postgres 9.6.1 accepts connections from not allowed Ip addresses
Date: 2016-11-17 15:45:35
Message-ID: CAM-w4HOAAJ3-47ZHcvXJjD4QNF9GYe+HjZpt0OGys5pVC0EdRw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Nov 17, 2016 at 10:58 AM, Jan Ogrodowczyk
<Jan(dot)Ogrodowczyk(at)qlik(dot)com> wrote:
> 4. The application is still connected to the database even though the
> access should be denied. As a matter of fact you are still able to write
> data to the database. Only when the remote application shuts its connection
> down and re-connects it is rejected by postgres.

This part makes me think the server was not in fact restarted at all.
Perhaps you just reloaded the config files which would not actually
disconnect already connected clients?

--
greg

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Julien Rouhaud 2016-11-17 21:31:59 Re: Index file got removed
Previous Message Tom Lane 2016-11-17 14:35:41 Re: Postgres 9.6.1 accepts connections from not allowed Ip addresses