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
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 |