Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YzcSS-0006kU-Tv for pgsql-admin@arkaria.postgresql.org; Tue, 02 Jun 2015 03:01:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YzcSS-0006QX-A8 for pgsql-admin@arkaria.postgresql.org; Tue, 02 Jun 2015 03:01:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YzcSQ-0006QN-9m for pgsql-admin@postgresql.org; Tue, 02 Jun 2015 03:01:38 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1YzcSJ-00008O-5e for pgsql-admin@postgresql.org; Tue, 02 Jun 2015 03:01:37 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id t5231S4A011999; Mon, 1 Jun 2015 23:01:28 -0400 From: Tom Lane To: "Guo, Yun" cc: "'Albe Laurenz'" , "pgsql-admin@postgresql.org" Subject: Re: pg_dump not dumping some schemas In-reply-to: References: <2DB6C5478F692C4C983B3129CC1AEB14CA65E8C8@HQ08HQMX002.cvent.net> <17196.1433168399@sss.pgh.pa.us> Comments: In-reply-to "Guo, Yun" message dated "Tue, 02 Jun 2015 02:39:59 -0000" Date: Mon, 01 Jun 2015 23:01:28 -0400 Message-ID: <11998.1433214088@sss.pgh.pa.us> X-Pg-Spam-Score: -1.5 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org "Guo, Yun" 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=0x654290, nspinfo=0x6600c0) at > pg_dump.c:7930 > 7930 { > (gdb) p nspinfo.dobj > $31 = {objType = DO_NAMESPACE, catId = {tableoid = 2615, oid = 17972}, > dumpId = 13, name = 0x660d80 "test", namespace = 0x0, > dump = 0 '\000', ext_member = 1 '\001', dependencies = 0x6e2b60, nDeps = 1, allocDeps = 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin