pg_migrator issue with contrib
От | Brad Nicholson |
---|---|
Тема | pg_migrator issue with contrib |
Дата | |
Msg-id | 1244230777.29189.26.camel@bnicholson-desktop обсуждение исходный текст |
Ответы |
Re: pg_migrator issue with contrib
|
Список | pgsql-hackers |
I've been kicking the tires on this a bit, and I've found an issue when dealing with contrib/ (specifically dblink, although I haven't looked around anymore). dblink_current_query() is not in the 8.4 version - when I run pg_migrator on an 8.3 cluster that has dblink installed, I get the following: Restoring database schema psql:/home/postgres/pg_migrator_dump_db.sql:271: ERROR: could not find function "dblink_current_query" in file "/opt/dbs/pgsql84-beta2/lib/dblink.so" There were problems executing "/opt/dbs/pgsql84-beta2/bin/psql" --set ON_ERROR_STOP=on --port 5432 -f "/home/postgres/pg_migrator_dump_db.sql" --dbname template1 >> "/dev/null" pg_migrator exits leaving me with a corrupted 8.3 instance. At the very least, a mention in the documentation of incompatible contrib module(s) would be nice. Even better would be a sanity check added to prevent this. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
В списке pgsql-hackers по дате отправления: