Re: pg_restore problem

"Roopali Sharma" <roopali(dot)sharma(at)waterford(dot)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