From: Tom Lane <tgl@sss.pgh.pa.us>
To: Magnus Hagander <magnus@hagander.net>
Cc: Christian Ullrich <chris@chrullrich.net>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Why does the WAL writer sit on completed segments (on Windows)?
Date: Mon, 17 Apr 2017 12:55:52 -0400
Message-ID: <7418.1492448152@sss.pgh.pa.us> (raw)
In-Reply-To: <CABUevEx6Kv2L9i0F_5id-SQkVda8d_sjuMV0dH-hZKbiTjwHhg@mail.gmail.com>
References: <od2lad$df0$1@blaine.gmane.org>
<17213.1492442911@sss.pgh.pa.us>
<CABUevEx6Kv2L9i0F_5id-SQkVda8d_sjuMV0dH-hZKbiTjwHhg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Magnus Hagander <magnus@hagander.net> writes:
> But all our files are opened with (FILE_SHARE_READ | FILE_SHARE_WRITE |
> FILE_SHARE_DELETE). So shouldn't this allow 7zip (or whatever) to open up
> the file, regardless of us holding it open? (Looking at
> https://msdn.microsoft.com/en-us/library/windows/desktop/aa363874(v=vs.85).aspx
> at least that's how I read it?)
My understanding of what Christian wrote is that 7zip is using flags
that specifically disallow "sharing". The flags we use will allow other
programs to open the file(s) with default options, but a program that
is deliberately trying to be the sole user of the file can still notice
our opens.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, magnus@hagander.net, chris@chrullrich.net
Subject: Re: Why does the WAL writer sit on completed segments (on Windows)?
In-Reply-To: <7418.1492448152@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox