From: "Guo, Yun" <YGuo@cvent.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: 'Albe Laurenz' <laurenz.albe@wien.gv.at>, "pgsql-admin@postgresql.org"
 <pgsql-admin@postgresql.org>
Subject: Re: pg_dump not dumping some schemas
Thread-Topic: [ADMIN] pg_dump not dumping some schemas
Thread-Index: 
 AQHQmWrG8qD1Kd5wwECxQFQUQc4hUJ2SmSMwgABZZgCABFkg4IAAXWMAgAAHsYCAAAXooIAARaiAgACLsgCAAEkQAIAAb84A
Date: Tue, 2 Jun 2015 13:41:39 +0000
Message-ID: <D19329C5.37A5E%yguo@cvent.com>
References: <D18CC6E9.36A0E%yguo@cvent.com>
 <A737B7A37273E048B164557ADEF4A58B36617951@ntex2010i.host.magwien.gv.at>
 <D18DE04B.36C72%yguo@cvent.com>
 <A737B7A37273E048B164557ADEF4A58B36618A43@ntex2010i.host.magwien.gv.at>
 <D191D463.3774F%yguo@cvent.com>
 <A737B7A37273E048B164557ADEF4A58B36618F30@ntex2010i.host.magwien.gv.at>
 <2DB6C5478F692C4C983B3129CC1AEB14CA65E8C8@HQ08HQMX002.cvent.net>
 <17196.1433168399@sss.pgh.pa.us> <D1928D1D.378F4%yguo@cvent.com>
 <11998.1433214088@sss.pgh.pa.us>
In-Reply-To: <11998.1433214088@sss.pgh.pa.us>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-MacOutlook/14.5.0.150423
Content-Type: text/plain; charset="Windows-1252"
Content-ID: <2BC253CD5E7AF44F8616B05B59FF014C@cvent.com>
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Interesting=8A I checked the pg_depend for that schema, looks like it=B9s
depending on an extension.

polling_etl=3D# SELECT classid, objid, refclassid, refobjid
FROM pg_depend
WHERE refclassid =3D 'pg_extension'::regclass
AND deptype =3D 'e'  and objid =3D 17972
ORDER BY 3,4;
 classid | objid | refclassid | refobjid
---------+-------+------------+----------
    2615 | 17972 |       3079 |    16730
		      ^^^^^^


polling_etl=3D# select * from pg_extension where oid =3D 16730;
 extname | extowner | extnamespace | extrelocatable | extversion |
extconfig | extcondition
---------+----------+--------------+----------------+------------+---------
--+--------------
 hstore  |       10 |        16389 | t              | 1.2        |
  |


How can I remove this dependency? Or what should I do to make it dump the
schema creation correctly?


On 6/1/15, 11:01 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

>"Guo, Yun" <YGuo@cvent.com> writes:
>> I tried gdb on selectDumpableNamespace() and dumpNamespace().
>> So it looks like for those problematic schemas,the dump value is 1 in
>> selectDumpableNamespace() which is correct, but when it goes to
>> dumpNamespace() the dump value becomes 0, so it get skipped.
>
>Oh really ...
>
>> Breakpoint 1, dumpNamespace (fout=3D0x654290, nspinfo=3D0x6600c0) at
>> pg_dump.c:7930
>> 7930	{
>> (gdb)  p nspinfo.dobj
>> $31 =3D {objType =3D DO_NAMESPACE, catId =3D {tableoid =3D 2615, oid =3D=
 17972},
>> dumpId =3D 13, name =3D 0x660d80 "test", namespace =3D 0x0,
>>   dump =3D 0 '\000', ext_member =3D 1 '\001', dependencies =3D 0x6e2b60,
>>nDeps =3D 1, allocDeps =3D 16}
>                     ^^^^^^^^^^^^^^
>
>There's the problem: this schema is marked as a member object of an
>extension, so it's not going to get dumped.  The expectation is that it'd
>be recreated during CREATE EXTENSION of whatever extension it belongs to.
>
>			regards, tom lane


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin