From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
---|---|
To: | PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem with 8.1's pg_dump -- not dumping a partition |
Date: | 2010-01-30 08:46:36 |
Message-ID: | 1264841196.32083.51.camel@hp-laptop2.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I just got an e-mail yesterday, regarding an issue with 8.1's pg_dump.
The problem is: Even if they use pg_dumpall, PostgreSQL does not dump
one of the partition, which is inherited by parent table. I don't have
access to the machine, so I don't know what the exact problem is -- is
this a known issue with 8.1? I thought 8.1 was able to track all
dependencies.
As I wrote, even pg_dumpall does not dump that partition, so they cannot
restore their dump now. This is more weird than pg_dump issue actually,
since I still expect pg_dumpall to dump everything in the cluster.
They are using 8.1.17, on Debian.
Their commands are:
* pg_dumpall -g ; pg_dump -Fc dbname
or
* pg_dumpall
I can ask for an access to the machines, if needed (they are not a
customer or such).
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2010-01-30 09:52:16 | Re: Changing FS when full |
Previous Message | Scott Marlowe | 2010-01-30 02:44:03 | Re: Possible to set postgres in case insensitive mode ? |