Re: [Gnumed-devel] Corrupt database

[Karsten Hilbert]

On Sat, Jun 01, 2013 at 03:42:25PM +0000, address@hidden wrote:

> I failed to capture all the errors while restoring data
> only from corrupt database.

So now you are in the same situation like before - you've
got a database which you know has errors and you don't know
which.

> Is there any log file I could find ?

Some bits will be in the PostgreSQL log.

> Insert or update on table keyword based expansion violets
> foreign key constraint keyword expansion fk staff fkey
> details: fk-staff=5 is not present in table staff 

Such things are to be expected, yes, and to be able to iron
them out we need to know them.

They are indicative of either missing config-like data (as
per Jerzy's wording) or faulty data - which we can then
remove the backup that is to be restored.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346