Re: Partition table data are not found in the pg_dump backup

Поиск
Список
Период
Сортировка
От Shrikant Bhende
Тема Re: Partition table data are not found in the pg_dump backup
Дата
Msg-id CADrerVUV_QR_i7LuFV5JMhLPQpXqbcx=w-pK4SR88p7Sm_iLkw@mail.gmail.com
обсуждение исходный текст
Ответ на Partition table data are not found in the pg_dump backup  (rajan <vgmonnet@gmail.com>)
Ответы Re: Partition table data are not found in the pg_dump backup  (rajan <vgmonnet@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Hi Rajan,

I have tried the same on my test machine and I don't see any issue while taking dump of the partitioned table, also command you have used is fine except -i option which is deprecated. Please confirm if you are not able to view data (after restore) in child tables or in parent table. Also you can try to take the dump of the one of the the partitioned table using -t option so that we can find out the exact issue. In normal scenario pg_dump works fine with the partitioned table.

On Mon, Apr 18, 2016 at 10:24 AM, rajan <vgmonnet@gmail.com> wrote:
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



--
Shrikant Bhende
+91-9975543712

В списке pgsql-admin по дате отправления:

Предыдущее
От: rajan
Дата:
Сообщение: Re: Partition table data are not found in the pg_dump backup
Следующее
От: Korry Douglas
Дата:
Сообщение: Re: Partition table data are not found in the pg_dump backup