Re: Lock out PostgreSQL users for maintenance

2012-05-12 06:29 keltezéssel, Alexander Farber írta:
> Or should I edit pg_hba.conf and restart the process?

host    all    postgres    127.0.0.1/32    md5
host    all    all         0.0.0.0/0        reject

Only postgres user is allowed to connect. You don't need
to restart the server, one of these would do:

killall -HUP postmaster
or
SELECT pg_reload_conf();

To kick out the current users except yourself, do:

SELECT pg_terminate_backend(procpid)
FROM pg_stat_activity WHERE procpid <> pg_backend_pid();

>
> Thank you
> Alex
>


--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig&  Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
      http://www.postgresql.at/