[pgpool-committers: 951] pgpool: Add a function "pgpool_pgctl()" which enebles to execute pg_ctl

[Nozomi Anzai]

Add a function "pgpool_pgctl()" which enebles to execute pg_ctl stop/restart/reload
(except for start) by SQL.

$ psql sales -c "select pgpool_pgctl('reload', 'fast')";
 pgpool_pgctl
--------------
 t
(1 row)

This function always ignores the actual result and returns 't',
so the user can't know if pg_ctl succeeded or failed.
To use this we have to set the custom variable for security
which limits the users to execute pg_ctl who has the permission of data directory.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=74fdfacf7adbdbee1abf5b5c9338dd5cdae02242

Modified Files
--------------
sql/pgpool-recovery/pgpool-recovery.c |   56 ++++++++++++++++++++++++++++++++-
1 files changed, 55 insertions(+), 1 deletions(-)