Re: Idea for fixing the Windows fsync problem

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Idea for fixing the Windows fsync problem
Дата
Msg-id 20070117081453.2AF7ADCC186@svr2.hagander.net
обсуждение исходный текст
Ответ на Re: Idea for fixing the Windows fsync problem  ("Takayuki Tsunakawa" <tsunakawa.takay@jp.fujitsu.com>)
Ответы Re: Idea for fixing the Windows fsync problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
>  BTW: what happens on Windows if we're trying to do the equivalent
> > of "rm -rf database-dir" and someone is holding open one of the
> files
> > in the directory?  Or has the directory itself open for readdir()?

For the first definity and I think for the second, when doing it from the commandline, you get a 'cannot delete the
directorybecause it is not empty'.
 
I'm not sure if our implementation for dealing with open files also work with directories.


> And I wonder what happens if Windows "copy" command is accessing the
> data files when bgwriter tries to open them for fsync, or the reverse
> of it.  copy would fail? 

Sharing violation.

> If so, it means that online backup sometimes
> fails.

Any backup software backing up *Anything* online should be using 
VSS or a custom OFM. and all real solutions do. 

/Magnus



В списке pgsql-hackers по дате отправления:

Предыдущее
От: tomas@tuxteam.de
Дата:
Сообщение: Re: Index for similarity search
Следующее
От: Hubert FONGARNAND
Дата:
Сообщение: Re: Temparary disable constraint