Re: pg_restore problem - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore problem
Date
Msg-id 23550.1077230545@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore problem  ("Roopali Sharma" <roopali.sharma@waterford.org>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inner join question
Next
From: Jim Crate
Date:
Subject: Slow queries in PL/PGSQL function