Table corruption and other questions

From: Miguel Montes <montes(at)noc(dot)unc(dot)edu(dot)ar>
To: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Table corruption and other questions
Date: 1999-11-29 19:18:59
Message-ID: 3842D1A2.74E05CC1@unc.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:
I'm using postgresql 6.5.1 with Linux Mandrake 6.1. I have two cases
of table corruption related to hardware failure. I have a server with
several clients generating nearly 10000 insertions a day. In both cases
one row of the table got corrupted, and caused the backend to crash when
trying to vacuum or execute pg_dump. SELECT * crashed the backend, too,
but we could do SELECTs on specific columns. The only way we could
recover the data was to do SELECT * FROM table WHERE id > n;
where n is the id of the corrupted row and was found by trial and error.

Is there a tool to repair a corrupted table?

Another question:
I'm using rules to log changes in several tables. I need this
because I have several servers in different locations, and I need to
synchronize them off line. The documentation isn't clear about the
relation between rules and permissions. The documentation i read implies
that a rule has the permissions of the user who is triggering its
execution. But it seems that this is not true, because a rule can insert
on a table over which the user has no privileges. This is exactly what i
need, but i'm not sure if this will be maintained in future versions. On
the other side, if a rule uses a function, it losts all its privileges,
and it can not insert in other tables if the user has no rights over
them.
Does anyone know if this is true, or i'm misunderstanding something?

TIA
Miguel Montes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 1999-11-29 21:06:49 Re: [GENERAL] Quoting/Escaping
Previous Message Bruce Momjian 1999-11-29 19:13:36 Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions