Re: pg_restore problem

"Roopali Sharma" <roopali.sharma@waterford.org> writes:
> I am trying to restore data from a production server (using Postgresql
> 7.3.x) to a test server using the latest release 7.4.1.
> It throws this error:
> pg_restore: [archiver (db)] could not execute query: ERROR:  could not
> find function "dblink_tok" in file "/usr/local/pgsql7.4.1/lib/dblink.so"

I see in the 7.3 dblink sources:

 * Note: dblink_tok is DEPRECATED;
 * it *will* be removed in favor of the new version on next release

and indeed it seems to be gone in 7.4.  Better update your code.

            regards, tom lane