Would it help to use a different filesystem like SGI's XFS ? Would it be possible to even implement that at you site at this stage ?

Tom Lane wrote:
Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:

We are trying to dump a 30GB+ database using pg_dump with the --file
option. In the beginning everything works fine, pg_dump runs and we get
a dumpfile. But when this file becomes 16GB it disappears from the
filesystem, pg_dump continues working without giving an error until it
finnish (even when the file does not exist)(The filesystem has free
space).


Is that a plain text, tar, or custom dump (-Ft or -Fc)?  Is the behavior
different if you just write to stdout instead of using --file?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

-- Aly Dharshi [EMAIL PROTECTED]

         "A good speech is like a good dress
          that's short enough to be interesting
          and long enough to cover the subject"

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to