On Mon, Jan 31, 2011 at 11:52, Fujii Masao <masao.fu...@gmail.com> wrote: > On Sat, Jan 29, 2011 at 1:11 AM, Tatsuo Ishii <is...@postgresql.org> wrote: >> Ok. I will write a C user function and add to pgpool source tree. I >> think it will be fairly easy to create a trigger file in the function. > > If the "pg_ctl promote" patch will have been committed, I recommend that > the C function should send the signal to the startup process rather than > creating the trigger file.
The C function needs to create a trigger file in $PGDATA/promote before sending signals, no? system("pg_ctl promote") seems the easiest way if you use an external module. -- Itagaki Takahiro -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers