Re: BUG #12050: Orphaned base files

Hi,

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

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

Thanks,
Jamie

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

On Tue, Jan 20, 2015 at 11:55 AM, Jamie Koceniak <jkoceniak@mediamath.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 you=
r system: do not mess up manually with those files and let the system manag=
e it. Be sure to at least take file-level backup if you go down this danger=
ous road.
--
Michael