Обсуждение: Partition table data not found in pg_dump

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






--
View this message in context: http://postgresql.nabble.com/Partition-table-data-not-found-in-pg-dump-tp5899056.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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