By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,799 Members | 1,379 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,799 IT Pros & Developers. It's quick & easy.

pg_restore problem

P: n/a
Hi,

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.
This is what I did:
1) dropdb -U postgres testdb
2) createdb -U postgres testdb
3) pg_restore -U postgres -O -d testdb data.tar
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"

Any help would be appreciated.

thanks
Roopali

*************************************
This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments..
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.
*************************************

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
"Roopali Sharma" <ro************@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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.