On 10/15/07, Jessica Richard <rjessil@xxxxxxxxx> wrote: > Thanks a lot! > > "select pg_cancel_backend(procpid) " can end the current query for that > user, but then this connection becomes IDLE, still connected. > > Is there a command for me to totally disconnect a user by procpid? Some > times, I need to kick out a particular Postgres user completely. >From the command line on the server you can issue a kill <pid> to do that. From within pgsql you'd need to write a function in an untrusted language to pull it off. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
