471,073 Members | 1,367 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

pg_restore problem

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
1 2270
"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.

Similar topics

reply views Thread by Joshua D. Drake | last post: by
14 posts views Thread by Ron Johnson | last post: by
6 posts views Thread by Mike Charnoky | last post: by
1 post views Thread by Plant Thomas | last post: by
reply views Thread by Stefano Bonnin | last post: by
7 posts views Thread by Tim Penhey | last post: by
1 post views Thread by Phil Endecott | last post: by
1 post views Thread by ruben | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.