signals??

Started by Joseph Shraibmanover 23 years ago4 messagesgeneral
Jump to latest
#1Joseph Shraibman
jks@selectacast.net

Looking at the Administrators guide (for 7.2.1) it does not list what signals a postgres
backend handles. I assume HUP makes it reread the config file, but what else is there?
Is there a way to cancel a currently running query by sending a signal?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Joseph Shraibman (#1)
Re: signals??

Joseph Shraibman <jks@selectacast.net> writes:

Looking at the Administrators guide (for 7.2.1) it does not list what signals a postgres
backend handles. I assume HUP makes it reread the config file, but what else is there?
Is there a way to cancel a currently running query by sending a
signal?

Sure, SIGINT to a backend implements query-cancel.

You are right that the postmaster and backend signal handlers are poorly
documented --- the details are all there in the sources, but the SGML
docs are pretty thin on the subject :-(. Care to dig around in the code
and submit some doc improvements?

regards, tom lane

#3Joseph Shraibman
jks@selectacast.net
In reply to: Joseph Shraibman (#1)
Re: signals??

Tom Lane wrote:

Joseph Shraibman <jks@selectacast.net> writes:

Looking at the Administrators guide (for 7.2.1) it does not list what signals a postgres
backend handles. I assume HUP makes it reread the config file, but what else is there?
Is there a way to cancel a currently running query by sending a
signal?

Sure, SIGINT to a backend implements query-cancel.

You are right that the postmaster and backend signal handlers are poorly
documented --- the details are all there in the sources, but the SGML
docs are pretty thin on the subject :-(. Care to dig around in the code
and submit some doc improvements?

regards, tom lane

I can't figure out which sgml file builds app-postgres.html file.

#4Joseph Shraibman
jks@selectacast.net
In reply to: Joseph Shraibman (#3)
Re: signals??

Could someone please tell me how to modify the sgml files in the cvs to change
app-postgres.html??

BTW if anyone emailed me the answer over the weekend it got lost, sorry :(

Joseph Shraibman wrote:

Show quoted text

Tom Lane wrote:

You are right that the postmaster and backend signal handlers are poorly
documented --- the details are all there in the sources, but the SGML
docs are pretty thin on the subject :-(. Care to dig around in the code
and submit some doc improvements?

regards, tom lane

I can't figure out which sgml file builds app-postgres.html file.