Re: pg_restore problem

Bradley Miller <bmiller@nuvio.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