On Sunday 13 June 2010 1:41:01 pm John T. Dow wrote: > I have information > > We had noticed two relations, their numbers being 16384/16642 and > 16384/16792. > > Here is what pg_class has for them. > > > "relname";"relnamespace";"reltype";"relowner";"relam";"relfilenode";"reltab >lespace";"relpages";"reltuples";"reltoastrelid";"reltoastidxid";"relhasindex >";"relisshared";"relistemp";"relkind";"relnatts";"relchecks";"relhasoids";"r >elhaspkey";"relhasrules";"relhastriggers";"relhassubclass";"relfrozenxid";"r >elacl";"reloptions" > > "pg_toast_16638";99;16643;16510;0;16642;0;0;0;0;16644;t;f;f;"t";3;0;f;t;f;f >;f;1581;"";"" > > "pg_toast_16788";99;16793;16510;0;16792;0;0;0;0;16794;t;f;f;"t";3;0;f;t;f;f >;f;2202;"";"" > > We also looked at the permissions and whether the files actually exist. > > Findings: The files are both marked "system file" and have size 0 K. When > logging on as an administrator and opening the files (eg with notepad, just > to see if there is nothing at all) they appear to be empty. Whose permissions do they have? > > However, while we were working on the problem, pgadmin3 started reporting > "permission denied" for 2611. At the same time, pgadmin was unable to see > the columns of the tables. Attempting to do so is what caused the error for > 2611. > > 2611 also appeared to be a system file with 0 bytes. What does Postgres think it is? Another TOAST table? > > Meantime, pgadmin was able to create a table and see the columns on the > standard postgres database. Now I am confused. What are you calling the standard Postgres database? > > Also, the Java application was able to see the columns and list them out as > well. Of which database? > > I have noticed that postgres is very unhappy if the proper "postgres" user > doesn't have access to the files. But I have also noticed that other users > seem to be able to have access without causing problems. I realize this > compromises security, but in a development environment it is very > convenient, eg when doing a system backup. Sort of the purpose of permissions :) > > Is it possible that some type of user might be causing files to be created > as or changed to system files, marked read only, and apparently empty? It would seem so. The question is whether this a historical artifact from corruption in the past or is ongoing? > > I am not certain which users have access to the files at the client's site, > but I know it's more than just the postgres user. > > All of these findings were on the second computer running XP. We ran out of > time today before we investigated the original server to see if it also had > system files marked read only with no apparent contents. > > John -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
