MCP Checking column on target database"ag_slave": "geom" (public.geometry)
[MonApr 20 18:04:19 2015] MCP FATAL: Source database for sync "ag_18b"has column "geom" of table "ac.xxtb_obstacle" astype "public.geometry", but target database "agis_slave"has a type of "public.geometry(GeometryZ,4326)"
Ihave a source system running Postgresql8.4.22 postgis 1.5.1 and the destination I am running postgrseql 9.1.10 POSTGIS 2.0.3 and bucardo_version is 4.5.0
I have tried many different ways but the outcome is always the same
I have a table called xxtb_obstacle. Icreate the table using DDL then add a geometry column
SELECTAddGeometryCobucardo_version = 4.5.0lumn ('ac','xxtb_obstacle','geom',4326,'GEOMETRY',3);
returns
"ac.xxtb_obstacle.geomSRID:4326 TYPE:GEOMETRY DIMS:3 "
select* from geometry_columns where f_table_name like 'xxtb_%'
returns
f_table_catalog| f_table_schema | f_table_name | f_geometry_column |coord_dimension | srid | type
-----------------+------------------+-----------------------+-------------------+-----------------+------+----------
| ac | xxtb_obstacle | geom | 3 | 4326 |GEOMETRY
Onmy destination side I am running postgrseql 9.1.10 POSTGIS 2.0.3 . I create the table using the same DDL then add the geometry column
SELECTAddGeometryColumn ('ac','xxtb_obstacle','geom',4326,'GEOMETRY',3);
addgeometrycolumn
-----------------------------------------------------------------------------
ac.xxtb_obstacle.geom SRID:4326TYPE:GEOMETRY DIMS:3
(1row)
agis=#select * from geometry_columns where f_table_name like 'xxtb_%'
agis-#;
f_table_catalog| f_table_schema | f_table_name | f_geometry_column |coord_dimension | srid | type
-----------------+------------------+-----------------------+-------------------+-----------------+------+----------
agis | ac | xxtb_obstacle | geom | 3 | 4326 | GEOMETRY
(1row)
Atthis point I have tow tables created from the same DDL and the same AddGeometryColumn function. When I start replicating (after addingthe table etc.) we get the following error.
MonApr 20 18:04:19 2015] MCP Checking column on target database"ag_slave": "geom" (public.geometry)
[MonApr 20 18:04:19 2015] MCP FATAL: Source database for sync "ag_18b"has column "geom" of table "ac.xxtb_obstacle" astype "public.geometry", but target database "agis_slave"has a type of "public.geometry(GeometryZ,4326)"
Theselect on geometry_columns show the same info. Do I need to dosomething about geometry columns in regards to bucardo?
Iam running
bucardo_current_version= 4.5.0
bucardo_version = 4.5.0
ifI redefine the geometry table as 2 dimensional I get a similar error
MCPFATAL: Source database for sync "agis_18b" has column"geom" of table "ac.xxtb_obstacle" as type"public.geometry", but target database "agis_slave"has a type of "public.geometry(Geometry,4326)"
Itseems to me that bucardo is seeing the metadata on this geometry in adifferent way. Both reflect the same.
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
