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(dot)klaver(at)aklaver(dot)com