Re: [ADMIN] OID and filesystem issues

2008-04-15 Thread Tom Lane
[EMAIL PROTECTED] writes: > Even when logged in as root, a 'ls -l' command returns: > mm2:/var/lib/pgsql82/data/base/16673 # ls -lash | more > /bin/ls: 19357877: Permission denied > /bin/ls: 19569529: Permission denied You get that as root? I think you've got filesystem problems that are beyond

Re: [ADMIN] OID and filesystem issues

2008-04-15 Thread lfedden
-- From: [EMAIL PROTECTED] Sent: 15 April 2008 15:44 To: Lee Fedden Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] OID and filesystem issues -- -- [EMAIL PROTECTED] writes: > 1) Does every relation exist in pg_

Re: [ADMIN] OID and filesystem issues

2008-04-15 Thread Tom Lane
[EMAIL PROTECTED] 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 coun