On 2012-05-12, Alexander Farber wrote:
> Hello,
>
> In PostgreSQL 8.4.9 with pgbouncer 1.3.4 in
> pool_mode = session (but some users connect to the
> database directly) - when I login as "super user" with
>
>psql -U postgres -W postgres
>
> What is the command please to disconnect all
> "norm
2012-05-12 06:29 keltezéssel, Alexander Farber írta:
Or should I edit pg_hba.conf and restart the process?
hostallpostgres127.0.0.1/32md5
hostallall 0.0.0.0/0reject
Only postgres user is allowed to connect. You don't need
to restart the server, one of th
On Sat, 12 May 2012 06:29:54 +0200
Alexander Farber wrote:
> Or should I edit pg_hba.conf and restart the process?
At least this is what we are doing. We are having a normal pg_hba.conf
and a pg_hba.conf for maintenance and switching on demand. Maybe not
the best solution, but its working ;)
C
Hello,
In PostgreSQL 8.4.9 with pgbouncer 1.3.4 in
pool_mode = session (but some users connect to the
database directly) - when I login as "super user" with
psql -U postgres -W postgres
What is the command please to disconnect all
"normal users" and prevent them from connecting
again while I
