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 input would be
appreciated.
thanks
Roopali Sharma
Software
Engineer
Waterford
Institute
Phone:
801.938.1713
*************************************
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.
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.
*************************************
