NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
# Restore the raw PostGresSQL dump on a computer with IMSMA V6.0;
# Scan the restore log for error messages;
#: the two error messages below are the so far '''encountered''' error messages but since table structure, relation rules between tables and contents of all {{IMSMANG}} databases are different there might be other error messages that you need to react on;
#:* error message ''COPY fieldreportdesc'' means that it was not possible to load the table so the table is '''empty''';
#:* error message ''ERROR: insert or update on table "fieldreport" violates foreign key constraint "fieldreport_fieldreportdesc_guid_fkey'' means mandatory reference between tables did not work because of missing values in e.g. imsmaenum table;
# Apply the ''fix imsmaenum Foreign Key constraints'' [[Imsmaenum FK fix | script]] ('''first''' time);
# Take backup;
