"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