index
pg-crash
[21 feb 05] i had a backup from 15-02
to get the db up:
some DBs which are for. keys for others. loaded
then the structure
and then i dropped (from the structure) all triggers/indexes etc
and loaded the single tables.
digging the log file:
i extract the time interval:
new programs `body'
i had to drop some single-line cruft
grep -F -f
i had to drop multiple-line queries (inserting HTML values)
todo: make those queuries `silent'
i made a program which removes stuff between 2 semi-fixed lines.
i need multi-line regexps !!!
replaying the logs:
- setting & checking the sequences.
-