Re: pg_restore problem

Bradley Miller <bmiller(at)nuvio(dot)com> writes:
> I'm attempting to restore a dump from one server to another (one is a
> Mac and one is a Linux base, if that makes any difference). I keep
> running into issues like this:

> pg_restore: [archiver (db)] could not execute query: ERROR: function
> public.random_page_link_id_gen() does not exist

Is this a problem of items in the dump being in the wrong order (ie,
there's a forward reference to random_page_link_id_gen())?

> Any suggestions on how to get around this problem?

Use 8.0 ... or use pg_restore's -L/-l options to manually adjust the
load order. Pre-8.0 versions of pg_dump are easily fooled if you use
ALTER to make earlier-created objects reference later-created objects.

regards, tom lane