Re: [GENERAL] Lock out PostgreSQL users for maintenance

2012-05-12 Thread Frank Lanitz
On Sat, 12 May 2012 06:29:54 +0200 Alexander Farber alexander.far...@gmail.com 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

Re: [GENERAL] Lock out PostgreSQL users for maintenance

2012-05-12 Thread Boszormenyi Zoltan
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

Re: [GENERAL] Lock out PostgreSQL users for maintenance

2012-05-12 Thread Jasen Betts
On 2012-05-12, Alexander Farber alexander.far...@gmail.com 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

[GENERAL] Lock out PostgreSQL users for maintenance

2012-05-11 Thread Alexander Farber
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