Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1as1Cf-0005CD-AY for pgsql-admin@arkaria.postgresql.org; Mon, 18 Apr 2016 04:54:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1as1Ce-0002O6-Pz for pgsql-admin@arkaria.postgresql.org; Mon, 18 Apr 2016 04:54:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1as1Ce-0002Nb-57 for pgsql-admin@postgresql.org; Mon, 18 Apr 2016 04:54:28 +0000 Received: from mbob.nabble.com ([162.253.133.15]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1as1Ca-0002PD-QA for pgsql-admin@postgresql.org; Mon, 18 Apr 2016 04:54:27 +0000 Received: from msam.nabble.com (unknown [162.253.133.85]) by mbob.nabble.com (Postfix) with ESMTP id 117F6257591D for ; Sun, 17 Apr 2016 21:41:07 -0700 (PDT) Date: Sun, 17 Apr 2016 21:54:22 -0700 (MST) From: rajan To: pgsql-admin@postgresql.org Message-ID: <1460955262913-5899193.post@n5.nabble.com> Subject: Partition table data are not found in the pg_dump backup MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.3 (/) 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 Partition tables are empty in backup while using pg_dump to take backup, but the actual tables in database have data. Below is the command used to take backup. ./pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f /tmp/dump.sql db_mydb ----- -- Thanks, Rajan. -- View this message in context: http://postgresql.nabble.com/Partition-table-data-are-not-found-in-the-pg-dump-backup-tp5899193.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin