Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YzQKv-0006Wt-Iy for pgsql-admin@arkaria.postgresql.org; Mon, 01 Jun 2015 14:05:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YzQKu-0005Pn-8Q for pgsql-admin@arkaria.postgresql.org; Mon, 01 Jun 2015 14:05:04 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YzQKt-0005Ph-FD for pgsql-admin@postgresql.org; Mon, 01 Jun 2015 14:05:03 +0000 Received: from smtp2.cvent.com ([65.97.54.246]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1YzQKq-0002G6-Kq for pgsql-admin@postgresql.org; Mon, 01 Jun 2015 14:05:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cvent.com; i=@cvent.com; q=dns/txt; s=c1211; t=1433167500; x=1464703500; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=96T3XmJhUXiJYTswBvO17b99tIAofbPefxeL/gNRr8A=; b=d2ZhDTYFVUzqmQe7B/fMYswIPEetsh/Kfrjvg68B6M6jEqDU8D9wUOT+ GFWqakLaoq+NBHHVQgvvh4ZfpiKaxMGq6w3VDRUJKLklHQiSrE8Wqw1Oq assJbJJwc2UpfDYdcJ3Ni18C6YJr+9dxBP7Nh7YmB+RIEfyuF3wwZoo8m U=; X-IronPort-AV: E=Sophos;i="5.13,533,1427774400"; d="scan'208";a="5497112" From: "Guo, Yun" To: Tom Lane CC: Albe Laurenz , "pgsql-admin@postgresql.org" Subject: Re: pg_dump not dumping some schemas Thread-Topic: [ADMIN] pg_dump not dumping some schemas Thread-Index: AQHQmWrG8qD1Kd5wwECxQFQUQc4hUJ2SmSMwgABZZgCABFkg4IAAXWMAgABLuID//8BGAA== Date: Mon, 1 Jun 2015 14:04:57 +0000 Message-ID: References: <16441.1433166781@sss.pgh.pa.us> In-Reply-To: <16441.1433166781@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.5.0.150423 Content-Type: text/plain; charset="iso-8859-1" Content-ID: Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Pg-Spam-Score: -2.0 (--) 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 Here=B9s the output: polling_etl=3D# SELECT oid FROM pg_catalog.pg_namespace n polling_etl-# WHERE n.nspname ~ '^(test)$'; oid ------- 17972 (1 row) polling_etl=3D# SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid =3D nspowner) AS rolname, nspacl FROM pg_catalog.pg_namespace; tableoid | oid | nspname | rolname | nspacl ----------+---------+--------------------+-----------+--------------------- ----------------------------------------------------------- 2615 | 99 | pg_toast | postgres | 2615 | 11215 | pg_temp_1 | postgres | 2615 | 11216 | pg_toast_temp_1 | postgres | 2615 | 11 | pg_catalog | postgres | {postgres=3DUC/postgres,=3DU/postgres} 2615 | 2200 | public | postgres | {postgres=3DUC/postgres,=3DUC/postgres} 2615 | 12348 | information_schema | postgres | {postgres=3DUC/postgres,=3DU/postgres} 2615 | 1131042 | test2 | pb_writer | {pb_writer=3DUC/pb_writer,test2=3DU/pb_writer} 2615 | 16389 | polling_etl | pb_writer | {pb_writer=3DUC/pb_writer,polling_etl=3DUC/pb_writer} 2615 | 17944 | mdev1 | pb_writer | {pb_writer=3DUC/pb_writer,=3DU/pb_writer,postgres=3DU*C/pb_writer,mdev1=3DU= /pb_writ er} 2615 | 17946 | mdev2 | pb_writer | {pb_writer=3DUC/pb_writer,=3DU/pb_writer,postgres=3DU*C/pb_writer,mdev2=3DU= /pb_writ er} 2615 | 17957 | mdev3 | pb_writer | {pb_writer=3DUC/pb_writer,=3DU/pb_writer,postgres=3DU*C/pb_writer,mdev3=3DU= /pb_writ er} 2615 | 17970 | mdev4 | pb_writer | {pb_writer=3DUC/pb_writer,=3DU/pb_writer,postgres=3DU*C/pb_writer,mdev4=3DU= /pb_writ er} 2615 | 17972 | test | pb_writer | {pb_writer=3DUC/pb_writer,=3DU/pb_writer,postgres=3DU*C/pb_writer,test=3DU/= pb_write r} (13 rows) pg_dump is missing 5 schemas: mdev1, mdev2, mdev3, mdev4, and test. It doesn=B9t look like much different between those 5 schemas and the other 2. On 6/1/15, 9:53 AM, "Tom Lane" wrote: > >SELECT oid FROM pg_catalog.pg_namespace n > WHERE n.nspname ~ '^(test)$'; --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin