Hello!
I tried to upgrade postgresql from v. 7.2.3 to 7.3.3.
I did pg_dump of the database and tried to read it in
using new version.
Below is a cut from my out file:
-- TOC Entry ID 101 (OID 16855)
--
-- Name: co_sys_meta_vtable_sqid Type: SEQUENCE Owner: root
--
CREATE SEQUENCE "co_sys_meta_vtable_sqid" start 1 increment 1 maxvalue
9223372036854775807 minvalue 1 cache 1;
--
-- TOC Entry ID 103 (OID 16855)
--
-- Name: co_sys_meta_vtable_sqid Type: ACL Owner:
--
REVOKE ALL on "co_sys_meta_vtable_sqid" from PUBLIC;
GRANT ALL on "co_sys_meta_vtable_sqid" to "root";
GRANT ALL on "co_sys_meta_vtable_sqid" to "nobody";
--
-- TOC Entry ID 411 (OID 16857)
--
-- Name: co_sys_meta_vtable Type: TABLE Owner: root
--
CREATE TABLE "co_sys_meta_vtable" (
"id" integer DEFAULT nextval('co_sys_meta_vtable_sqid'::text),
"version" integer DEFAULT 0,
"deleted" integer DEFAULT 0,
"inherits_acl" integer DEFAULT 1,
"area" text DEFAULT 'sys',
"class_name" text DEFAULT '',
"method_name" text DEFAULT '',
"target_area" text DEFAULT 'sys',
"target_class_name" text DEFAULT '',
"id_permission" integer DEFAULT '',
"id_onbefore_script" integer DEFAULT 0,
"id_onbefore_method" integer DEFAULT 0,
"id_script" integer DEFAULT 0,
"id_onafter_script" integer DEFAULT 0,
"id_onafter_method" integer DEFAULT 0,
"profiled" integer DEFAULT 0,
"sec_type" integer DEFAULT 0,
"force_sec_type" integer DEFAULT 0
);
--
-- TOC Entry ID 412 (OID 16857)
--
-- Name: co_sys_meta_vtable Type: ACL Owner:
--
REVOKE ALL on "co_sys_meta_vtable" from PUBLIC;
GRANT ALL on "co_sys_meta_vtable" to "root";
GRANT ALL on "co_sys_meta_vtable" to "nobody";
I get an pg_atoi error while reading in co_sys_meta_vtable,
I suppose at this
"id" integer DEFAULT nextval('co_sys_meta_vtable_sqid'::text),
particular line.
Is there a way to successfully transport such a db into new version?
The dump has almost 3G, so hand-editing is not a case..
TIA,
--
Marcin Gil
marcin.gil @ audax.com.pl, tel. 694972082
OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
tel/fax (44) 7247530, 7244401