Re: BUG #12050: Orphaned base files

Hi,

If I don't remove the orphaned files, is there any change that Postgres could use the same file node (oid) again?

For example, say file node 2602351127 doesn't exist anywhere in pg_class, could Postgres use that same file node id again?
What would happen in that case?

Thanks,
Jamie

-----Original Message-----
From: Michael Paquier [mailto:michael(dot)paquier(at)gmail(dot)com]
Sent: Tuesday, January 20, 2015 6:59 PM
To: Jamie Koceniak
Cc: Tom Lane; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #12050: Orphaned base files

On Tue, Jan 20, 2015 at 11:55 AM, Jamie Koceniak <jkoceniak(at)mediamath(dot)com> wrote:
> Is it safe to remove the files /postgresql/9.1/main/base/31858 directory?
The general rule is usually the following if you do not want to corrupt your system: do not mess up manually with those files and let the system manage it. Be sure to at least take file-level backup if you go down this dangerous road.
--
Michael