Re: Partition table data not found in pg_dump - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Partition table data not found in pg_dump
Date
Msg-id 571A2DE3.9040009@aklaver.com
Whole thread Raw
In response to Partition table data not found in pg_dump  (vinothcanwin <vincanwin@gmail.com>)
List pgsql-general
On 04/15/2016 11:35 PM, vinothcanwin wrote:
> Partition tables are empty in backup while using pg_dump to take backup, but
> those tables having data in database. Below is the command i am using to
> take backup.
>
> ./pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f /tmp/dump.sql
> db_mydb
>

Not seeing much wrong above. FYI, -i is deprecated/ignored and -b is
only needed if you are doing a selective dump, which is not the case here.

Are you sure you are pointing at the right database?



--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: Proper relational database?
Next
From: John McKown
Date:
Subject: Re: Proper relational database?