pg_restore problems

Поиск
Список
Период
Сортировка
От Roopali Sharma
Тема pg_restore problems
Дата
Msg-id 661FA176BD6D144F91CE5DDCA6A9260208F983@postoffice.waterford.org
обсуждение исходный текст
Список pgsql-bugs
Hi,
=20
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"
=20
Any input would be appreciated.
=20
thanks
Roopali Sharma
Software Engineer
Waterford Institute
Phone: 801.938.1713=20
=20=20
*************************************=20
This e-mail may contain privileged or confidential material intended for th=
e named recipient only.=20
If you are not the named recipient, delete this message and all attachments=
.=20
Unauthorized reviewing, copying, printing, disclosing, or otherwise using i=
nformation in this e-mail is prohibited.=20
We reserve the right to monitor e-mail sent through our network.=20=20
*************************************=20

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Select (str)::FLOAT8 BUG
Следующее
От: Shelby Cain
Дата:
Сообщение: ecpg mapping struct members for indicators incorrectly?