Re: pg_ctl vs. Windows locking

Andrew Dunstan <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
Tom Lane wrote:

>Andrew Dunstan <[email protected]> writes:
>  
>
>>When I was watching it in the Task Manager, it was observable that the 
>>postmaster exited before some of the other backend processes, by up to a 
>>second or two.
>>    
>>
>
>The stats collector processes normally don't shut down until they
>observe postmaster exit (and I think in CVS tip there's an
>up-to-one-second delay before they'll even look).  Everything else
>should be gone first though.
>
>  
>

I assumed it was them. Can't tell in Task Manager, that I can see - all 
you get is the image name :-(

Sounds like a 2 second sleep should do the trick. Will test later.

Maybe we should do it everywhere, not just Windows, to ensure that we 
don't get nasty interleaving on the log file?

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.