pg_migrator issue with contrib

Поиск
Список
Период
Сортировка
Искать
От
Brad Nicholson
Тема
pg_migrator issue with contrib
Дата
Msg-id
1244230777.29189.26.camel@bnicholson-desktop
Список
Дерево обсуждения
pg_migrator issue with contrib Brad Nicholson <bnichols@ca.afilias.info>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Dimitri Fontaine <dfontaine@hi-media.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib David Blewett <david@dawninglight.net>
Re: pg_migrator issue with contrib Brad Nicholson <bnichols@ca.afilias.info>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Andrew Dunstan <andrew@dunslane.net>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Josh Berkus <josh@agliodbs.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Josh Berkus <josh@agliodbs.com>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Grzegorz Jaskiewicz <gj@pointblue.com.pl>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Grzegorz Jaskiewicz <gj@pointblue.com.pl>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Merlin Moncure <mmoncure@gmail.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: pg_migrator issue with contrib Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Josh Berkus <josh@agliodbs.com>
Re: pg_migrator issue with contrib Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Alvaro Herrera <alvherre@commandprompt.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Dimitri Fontaine <dfontaine@hi-media.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Magnus Hagander <magnus@hagander.net>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Magnus Hagander <magnus@hagander.net>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Dimitri Fontaine <dfontaine@hi-media.com>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Dimitri Fontaine <dfontaine@hi-media.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Dimitri Fontaine <dfontaine@hi-media.com>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator issue with contrib Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
Re: pg_migrator issue with contrib Bruce Momjian <bruce@momjian.us>
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 по дате отправления
От: Aidan Van Dyk
Дата:
От: Bruce Momjian
Дата:
FAQ