Zdenek Kotala wrote:
> 3) My personal favorite is create management console - which allows to
> perform check without physically access to local machine. Management
> console should be use for another purpose - for example disable/enable
> databases from cluster, perform upgrade of datalayer to the new version,
> kill sessions, update postgresql.conf and so on...
>
> However this solution has significant impact on current postgres
> behavior, but I think it should be big deal for postgres.

I believe pgadmin lets you update postgresql.conf remotely, and I know
you can kill sessions from within PG ( pg_cancel_backend() ).

For the rest, that's what ssh is for imho.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate