to answer to Adrian
1) i am using the old version to dump (i will try with the latest) 2) no the postgis version is different. pg9.2.4-> postgis-2.0.3 and pg9.3.5-> postgis-2.1.3 3) the schema is public \d+ al_shared_place Table "public.al_shared_place" Column | Type | Modifiers | Storage | Stats target | Description ------------+-----------------------+---------------------------------------------------------------+----------+--------------+------------- id | integer | not null default nextval(('al_landmark_seq'::text)::regclass) | plain | | x | character varying(15) | | extended | | y | character varying(15) | | extended | | name | character varying(50) | | extended | | placetype | integer | | plain | | point_geom | geometry | | main | | Indexes: "al_shared_place_pkey" PRIMARY KEY, btree (id) "al_sharedplace_geom_idx" gist (point_geom) Check constraints: "$1" CHECK (srid(point_geom) = 4326) "$2" CHECK (geometrytype(point_geom) = 'POINT'::text OR point_geom IS NULL) Has OIDs: no -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827747.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general