Postgres Pro
Downloads
Home   >   mailing lists

Thread: TODO item: Allow the server to be stopped/restarted via an SQL API

TODO item: Allow the server to be stopped/restarted via an SQL API

From
"Aleksis Petrov"
Date:
Hi all,<br /><br />Would it be acceptable to invoke pg_ctl in the API functions to stop and restart the server?<br
/><br/>thanks<br />

Re: TODO item: Allow the server to be stopped/restarted via an SQL API

From
Tom Lane
Date:
"Aleksis Petrov" <a.aleksis@gmail.com> writes:
> Would it be acceptable to invoke pg_ctl in the API functions to stop and
> restart the server?

No.  Not everyone uses pg_ctl for that.
        regards, tom lane

Re: TODO item: Allow the server to be stopped/restarted via an SQL API

From
"Aleksis Petrov"
Date:
Via signal handling? Use the kill() function (or its pg equivalent) to send the appropriate signal?

On 4/6/07, Tom Lane < tgl@sss.pgh.pa.us> wrote:
"Aleksis Petrov" < a.aleksis@gmail.com> writes:
> Would it be acceptable to invoke pg_ctl in the API functions to stop and
> restart the server?

No.  Not everyone uses pg_ctl for that.

                        regards, tom lane