pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPartition table data are not found in the pg_dump backup
5+ messages / 3 participants
[nested] [flat]
* Partition table data are not found in the pg_dump backup
@ 2016-04-18 04:54 rajan <vgmonnet@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: rajan @ 2016-04-18 04:54 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Partition table data are not found in the pg_dump backup
@ 2016-04-21 07:35 rajan <vgmonnet@gmail.com>
parent: rajan <vgmonnet@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: rajan @ 2016-04-21 07:35 UTC (permalink / raw)
To: pgsql-admin
Can you anyone help me on this?
-----
--
Thanks,
Rajan.
--
View this message in context: http://postgresql.nabble.com/Partition-table-data-are-not-found-in-the-pg-dump-backup-tp5899193p5899...
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Partition table data are not found in the pg_dump backup
@ 2016-04-21 11:29 Shrikant Bhende <shrikantbhende.net@gmail.com>
parent: rajan <vgmonnet@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Shrikant Bhende @ 2016-04-21 11:29 UTC (permalink / raw)
To: rajan <vgmonnet@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Partition table data are not found in the pg_dump backup
@ 2016-04-21 12:27 Korry Douglas <korry.douglas@enterprisedb.com>
parent: rajan <vgmonnet@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Korry Douglas @ 2016-04-21 12:27 UTC (permalink / raw)
To: rajan <vgmonnet@gmail.com>; +Cc: pgsql-admin
Hi Rajan - if you are using an EnterpriseDB product, you should contact
EnterpriseDB Technical Support and we'll help get your issues resolved.
-- Korry
> Can you anyone help me on this?
>
>
>
> -----
> --
> Thanks,
> Rajan.
> --
> View this message in context: http://postgresql.nabble.com/Partition-table-data-are-not-found-in-the-pg-dump-backup-tp5899193p5899...
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Partition table data are not found in the pg_dump backup
@ 2016-04-22 04:12 rajan <vgmonnet@gmail.com>
parent: Shrikant Bhende <shrikantbhende.net@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: rajan @ 2016-04-22 04:12 UTC (permalink / raw)
To: pgsql-admin
Hello Shrikant,
Thanks for your help. We are able to restore the data from our pg_dump
backup.
Hello Korry,
Thanks for your support.
-----
--
Thanks,
Rajan.
--
View this message in context: http://postgresql.nabble.com/Partition-table-data-are-not-found-in-the-pg-dump-backup-tp5899193p5899...
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2016-04-22 04:12 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-04-18 04:54 Partition table data are not found in the pg_dump backup rajan <vgmonnet@gmail.com>
2016-04-21 07:35 ` rajan <vgmonnet@gmail.com>
2016-04-21 12:27 ` Korry Douglas <korry.douglas@enterprisedb.com>
2016-04-21 11:29 ` Shrikant Bhende <shrikantbhende.net@gmail.com>
2016-04-22 04:12 ` rajan <vgmonnet@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox