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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
