Re: pgdump (9.2.4) not dumping all tables

From: Marcos Cano <mcano(at)stsa(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pgdump (9.2.4) not dumping all tables
Date: 2014-11-20 18:29:19
Message-ID: 1416508159204-5827747.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2014-11-20 18:40:41 Re: pgdump (9.2.4) not dumping all tables
Previous Message Marcos Cano 2014-11-20 18:25:10 Re: pgdump (9.2.4) not dumping all tables