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