Brian Ristuccia <[EMAIL PROTECTED]> writes: > The standalone backend errors out with: > FATAL 1: _mdfd_getrelnfd: cannot open relation pg_trigger: No such file or > directory
Well, if you can identify which of the lost+found files is pg_trigger, you can move it back into place and then try again. (Look for trigger names in the od -c dump...) All the system tables have fixed names (relfilenode values) which you can determine by consulting another database of the same PG version. pg_trigger is 16412 in 7.3, for instance. Lather, rinse, repeat until it comes up ... > My week-old backups are starting to look more and more attractive. I didn't say this was going to be painless. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly