Re: [ADMIN] Forcing connections closed

2004-02-02 Thread Spiegelberg, Greg
t the tcp_keepalive_time back when you're done. Just random thoughts. Greg -Original Message- From: Juan Miguel To: PGSQL Admin Sent: 2/1/04 4:47 PM Subject: Re: [ADMIN] Forcing connections closed >'kill -9' PID will force all backends to flush cache for no good reason. >

Re: [ADMIN] Forcing connections closed

2004-02-01 Thread Juan Miguel
'kill -9' PID will force all backends to flush cache for no good reason. Note that on most unixes, a plain kill PID will send the term signal, which tells the process to poltely shutdown and release resources. kill -9 is like using a sledge hammer to swat a fly for this. -

Re: [ADMIN] Forcing connections closed

2004-01-29 Thread Andrew Rawnsley
t complete shutdown; will lead to recovery on restart HTH, Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Hadley Willan [mailto:[EMAIL PROTECTED] Sent: Thu 1/29/2004 1:03 PM To: PGSQL Admin Cc: Subject: [ADMIN] Forcing connections closed Hello, How

Re: [ADMIN] Forcing connections closed

2004-01-29 Thread scott.marlowe
On Thu, 29 Jan 2004, Juan Miguel wrote: > You can kill the procs (connections) using kill -9 PID Just use kill PID first! 'kill -9' PID will force all backends to flush cache for no good reason. Note that on most unixes, a plain kill PID will send the term signal, which tells the process to po

Re: [ADMIN] Forcing connections closed

2004-01-29 Thread Juan Miguel
PM To: PGSQL Admin Cc: Subject:[ADMIN] Forcing connections closed Hello, How do I force postmaster to terminate active connections on other databases? Thanks ---(end of broadcast)--- TIP 9: the planner will ignore your desire to c

Re: [ADMIN] Forcing connections closed

2004-01-29 Thread Ryan Chambers
quit without complete shutdown; will lead to recovery on restart HTH, Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Hadley Willan [mailto:[EMAIL PROTECTED]] Sent: Thu 1/29/2004 1:03 PM To: PGSQL Admin Cc: Subject: [ADMIN] Forcing connections closed Hello,

Re: [ADMIN] Forcing connections closed

2004-01-29 Thread Hadley Willan
quit directly, with proper shutdown immediate quit without complete shutdown; will lead to recovery on restart HTH, Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Hadley Willan [mailto:[EMAIL PROTECTED] Sent: Thu 1/29/2004 1:03 PM To: PGSQL Admin Cc: Subject: [ADMIN] Fo

Re: [ADMIN] Forcing connections closed

2004-01-29 Thread Gregory S. Williamson
shutdown immediate quit without complete shutdown; will lead to recovery on restart HTH, Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Hadley Willan [mailto:[EMAIL PROTECTED] Sent: Thu 1/29/2004 1:03 PM To: PGSQL Admin Cc: Subject:[ADMIN] Forcing

[ADMIN] Forcing connections closed

2004-01-29 Thread Hadley Willan
Hello,     How do I force postmaster to terminate active connections on other databases? Thanks -- Hadley Willan » Director » [EMAIL PROTECTED] » +64(21) 28 41 463 Deeper Design Limited » +64(7) 377 3328 » www.deeperdesign.com