Re: Deleted files still open long after droping a database - Mailing list pgsql-general

From Vincent de Phily
Subject Re: Deleted files still open long after droping a database
Date
Msg-id 1866412.G1gpuDE31P@moltowork
Whole thread Raw
In response to Re: Deleted files still open long after droping a database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Monday 17 February 2014 21:14:35 Tom Lane wrote:
> Kevin Grittner <kgrittn@ymail.com> writes:
> > Perhaps we should arrange for a DROP DATABASE command to somehow
> > signal all backends to close files from that backend?
>
> See commit ff3f9c8de, which was back-patched into 9.1.x as of 9.1.7.
>
> Unfortunately, the complainant is running 9.1.2.

Thanks for the detailed info, great to see it's already fixed. As it happens,
we're in the process of moving to new servers, where we'll strive to get a
better update process going.

--
Vincent de Phily


pgsql-general by date:

Previous
From: "Sofer, Yuval"
Date:
Subject: Postgres service (Windows) running as "local system"
Next
From: 邓尧
Date:
Subject: How to discard partially retrieved result set with the C API?