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

Reply via email to