Message-Id: <4F9161CEA8.07DC005BTFSFDCZG@contextworld.com>
From: lfedden@contextworld.com
Date: Tue, 15 Apr 2008 10:00:26 +0100
To: pgsql-admin@postgresql.org
Subject: OID and filesystem issues
MIME-version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable


Hi All,

I have a couple of questions hopefully someone can help me with=2E

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

2) If we remove such file and run vaccum or pg_dump will we get into=20=
troubles ? Where does vaccum take information about relations from?=20=
pg_class or filesystem ?

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

Thanks
Lee=2E=20=
*****************************************************
Lee Fedden
Software Developer
CONTEXT
Tel:+44 (0)20 8394 7724
Fax:+44 (0)20 8394 7701
Email Address: lfedden@contextworld=2Ecom
Web Site: http://www=2Econtextworld=2Ecom
*****************************************************
This message and the information contained therein is intended for the use
of the person(s) ("the intended  recipient(s)" to whom it is addressed=2E It
may contain information that is privileged and confidential within the
meaning of applicable law=2E If you are not the intended recipient, please
contact the sender as soon possible=2E The views expressed in this
communication may not necessarily  be the views held by Context Business
Limited or its subsidiaries=2E The contents of an attachment to this e-mail
may contain viruses that could damage your own computer system=2E While every
reasonable precaution has been taken to minimise this risk, Context Business
Limited and its subsidiaries cannot  accept liability for any damage which
you sustain  as a result of software viruses=2E You should carry out your own
virus checks
before opening the attachment=2E Please notice that Context Business Limited
monitors e-mails sent or received=2E Further communication will signify your
consent to this=2E

Context Business Limited, a Company registered in England under number
06298773=2E Registered Directors Jeremy Davies and Howard Davies=2E
Registered office address: 10-18 Putney Hill, London, SW15 6AA
VAT 919 7799 50