Re: [HACKERS] [GENERAL] Unable to get postgres running after long time no vacuum

2007-07-08 Thread Alvaro Herrera
Tom Lane wrote: > No, it's orthogonal to whether we want a "quit" command. (My opinion is > not, because what the heck will we do with it in multiuser mode? And > there is no good way to shoehorn it into just the single-user mode, it'd > have to be a grammar entry.) Hmm, I was thinking that we

Re: [HACKERS] [GENERAL] Unable to get postgres running after long time no vacuum

2007-07-08 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Sure, but those who do know how to SIGQUIT might reach for that before >> they reach for control-D. There's hardly anyone out there who could >> be called an experienced user of the standalone mode, I think, and so >> we shouldn't ass

Re: [HACKERS] [GENERAL] Unable to get postgres running after long time no vacuum

2007-07-08 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> At least on my machine there doesn't seem to be a defined way to > >> generate SIGTERM from the terminal; so I can see where if someone hasn't > >> read the postgres man page carefully, their first instinct upon f

Re: [HACKERS] [GENERAL] Unable to get postgres running after long time no vacuum

2007-07-08 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> At least on my machine there doesn't seem to be a defined way to >> generate SIGTERM from the terminal; so I can see where if someone hasn't >> read the postgres man page carefully, their first instinct upon finding >> that control-C d

Re: [HACKERS] [GENERAL] Unable to get postgres running after long time no vacuum

2007-07-08 Thread Alvaro Herrera
Tom Lane wrote: > "Leon Mergen" <[EMAIL PROTECTED]> writes: > > On 7/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: > >> It's actually not that easy to get out of the single-user mode without > >> it doing a checkpoint. I suppose you must have either SIGQUIT or > >> SIGKILL'd it. While there's nothing

Re: [HACKERS] [GENERAL] Unable to get postgres running after long time no vacuum

2007-07-08 Thread Tom Lane
"Leon Mergen" <[EMAIL PROTECTED]> writes: > On 7/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: >> It's actually not that easy to get out of the single-user mode without >> it doing a checkpoint. I suppose you must have either SIGQUIT or >> SIGKILL'd it. While there's nothing we can do about SIGKILL,

Re: [HACKERS] [GENERAL] Unable to get postgres running after long time no vacuum

2007-07-08 Thread Tom Lane
"Leon Mergen" <[EMAIL PROTECTED]> writes: >> Perhaps you are not shutting down the standalone mode cleanly after >> the vacuum? > Okay, that was obviously it -- I didn't realize I needed to send a > crtl+D signal to the server when in single user mode to shut it down, > and figured that any uncomm