some useless files may be left behind ?

From: Bo Thorbjørn Jensen <bo(at)budget123(dot)dk>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: some useless files may be left behind ?
Date: 2015-04-30 11:13:36
Message-ID: AD7252BEFBCA3846A8D34ABCDA258D08548DA1DF@EXMBX04.mailcloud.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

We have a cluster on windows 2008 server "PostgreSQL 9.1.15, compiled by Visual C++ build 1500, 64-bit"
After trying to create new databases concurrently npgsql endpoint reached default commandtimeout (20 seconds).

This results in following log entries on the server:
2015-04-30 08:47:14 CEST WARNING: could not remove file or directory "base/64111031": Directory not empty
2015-04-30 08:47:14 CEST WARNING: some useless files may be left behind in old database directory "base/64111031"
2015-04-30 08:47:14 CEST ERROR: canceling statement due to user request
2015-04-30 08:47:14 CEST STATEMENT: CREATE DATABASE database WITH ENCODING='UTF8' OWNER=owner TEMPLATE=custom_template

The directory is empty now.
Question is, will auto vacuum clean this up eventually?
Should I be concerned ?

Any thoughts or comments are appreciated. Thanks!

Bo Thorbjørn Jensen

Browse pgsql-general by date

  From Date Subject
Next Message Fabio Ugo Venchiarutti 2015-04-30 13:02:15 Re: PostgreSQL HA config recommendations
Previous Message Mitu Verma 2015-04-30 10:58:27 Re: clearing of the transactions shown in pg_locks