Re: OID and filesystem issues

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lfedden(at)contextworld(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: OID and filesystem issues
Date: 2008-04-15 14:43:56
Message-ID: 13347.1208270636@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

lfedden(at)contextworld(dot)com writes:
> 1) Does every relation exist in pg_class? Can we assume that if there is a file with OID which is not present in pg_class, this file can be deleted? (we have a few such files, some of them take more than 2G of space in total)

You do know it's relfilenode that counts, not OID?

As long as you are paying attention to the right column, yes, you could
remove any file that doesn't correspond to a live pg_class row. It's
not a common situation though so I'd definitely triple-check first.

> 3) We have a relation which is unaccessible (permission denied), ls -l also prints this message so it's something with filesystem. What would be the best procedure to solve this issue ?

Fix the ownership/permissions with chown/chmod, as needed. Pretty much
all files in a database should be alike in this regard (postgres-owned,
mode 0600).

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lfedden 2008-04-15 15:25:22 Re: OID and filesystem issues
Previous Message Joshua Kramer 2008-04-15 13:22:59 Re: Deploying Postgresql Along My Windows App