migrating data from 7.3.x down to 7.2.x
От | Stefan Armbruster |
---|---|
Тема | migrating data from 7.3.x down to 7.2.x |
Дата | |
Msg-id | 1058191489.1989.49.camel@emperor.local обсуждение исходный текст |
Ответы |
Re: migrating data from 7.3.x down to 7.2.x
|
Список | pgsql-general |
Hi, I tried to migrate a database from 7.3.2 down to PostgreSQL 7.2.2 and got some trouble. The database contains various plpgsql triggers. Here what I tried: On the machine running 7.3.2, I typed: pg_dump -U sguru sguru_test > sguru.dmp sguru.dmp is a text-style file. I copied sguru.dmp to the maschine running 7.2.2 and typed there createdb -U postgres sguru_test psql -f sguru.dmp sguru_test sguru It gives me some errors, see below. My next step was to connect pg_dump remotely from the 7.2.2 box to dump the 7.3.2 database (with -i option). This gave me this error. pg_dump: query to obtain list of data types failed: ERROR: Attribute "typprtlen" not found I think, the 7.3.2 dump file format uses some syntax 7.2.2 does not understand. Is there a way to force 7.3.2's pg_dump to produce a 7.2.2 compatible output? Or any other suggestions? Kind regards, Stefan ***************** ERRORS of psql call ******************************** You are now connected as new user postgres. psql:sguru.dmp:7: ERROR: parser: parse error at or near "public" psql:sguru.dmp:16: NOTICE: ProcedureCreate: type language_handler is not yet defined CREATE psql:sguru.dmp:24: ERROR: PL handler function plpgsql_call_handler() isn't of return type Opaque You are now connected as new user sguru. psql:sguru.dmp:29: ERROR: parser: parse error at or near "public" ... ... ***************** The first lines of sguru.dmp are ******************** -- -- PostgreSQL database dump -- \connect - postgres SET search_path = public, pg_catalog; -- -- TOC entry 163 (OID 29597) -- Name: plpgsql_call_handler (); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler AS '$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE c; -- -- TOC entry 162 (OID 29598) -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: -- CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler; \connect - sguru SET search_path = public, pg_catalog; -- -- TOC entry 2 (OID 29599) -- Name: mail_spooler; Type: TABLE; Schema: public; Owner: sguru -- CREATE TABLE mail_spooler ( objectid numeric(19,0) NOT NULL, trial smallint, error_msg character varying(255), to_adr character varying(255) NOT NULL, subject character varying(255), body text, objectversion integer NOT NULL, from_adr character varying(50) NOT NULL, cc_adr character varying(255), bcc_adr character varying(255) );
В списке pgsql-general по дате отправления: