Skip site navigation (1) Skip section navigation (2)

Dumb unlink question

From: Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com>
To: pgsql-hackers-win32 <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Dumb unlink question
Date: 2003-10-30 04:33:02
Message-ID: A02DEC4D1073D611BAE8525405FCCE2B027FDB@harris.memetrics.local (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Hi all,

was looking at pgunlink, the win32 unlink replacement for postgres, and was
wondering if it is instead possible (not necessarily make sense to, but
possible):
	- to simply try the unlink call once, and
	- if unsuccessful with EACCES, mark the file to be deleted some
later time (ie. next postmaster restart, on system reboot with MoveFileEx,
...)

Clearly, this would become burdensome if the file is ever likely to be
reused again. 

So, my question boils down to, effectively, do unlinked files ever get
rebirthed (eg. if postgres unlinks the file $PGDATA\base\17138, for
instance, can I ever expect to see this file appear again at a later date?)
in routine use, or does postgres use ever-increasing file numbers. Perhaps
after a restore?

Cheers,
Claudio

--- 
WE HAVE MOVED - PLEASE NOTE OUR NEW CONTACT DETAILS: 
THE BASEMENT, 33 EWELL STREET, BALMAIN NSW 2041 
TEL: +61 2 9555 1544 FAX: +61 2 9555 6911 
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see 
http://www.memetrics.com/emailpolicy.html

Responses

pgsql-hackers-win32 by date

Next:From: Andrew DunstanDate: 2003-10-31 17:23:18
Subject: status?
Previous:From: Andrew DunstanDate: 2003-10-29 04:17:11
Subject: Re: pg_ctl reports succes when start fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group