Re: Error message using pg_dump with tar format - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Error message using pg_dump with tar format
Date
Msg-id Pine.LNX.4.33.0307100950160.10734-100000@css120.ihs.com
Whole thread Raw
In response to Re: Error message using pg_dump with tar format  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
On Thu, 10 Jul 2003, Nick Fankhauser wrote:

>
> > Are you sure you're not running:
> >
> > pg_dump -Ft prod > prod.dump.tar
>
> You are correct- I mis-typed the command in my message.
>
>
> > Maybe a file size limit on that box is being hit?
>
> No, the text dump is creating a larger file successfully, so I don't think
> that is the cause. There's plenty of disk space, and the file is well under
> 1GB when the dump quits. The file size limit on the OS is 2GB in our case.
>
> Thanks for the correction & idea.

Make sure you're not hitting any quote limits.  Try just writing a file
(i.e. dd if=/dev/zero of=/backupdir/filename blocks=5000000 or something
like that.

Try backing up to /dev/null and see if you get the same error.




pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: Error message using pg_dump with tar format
Next
From: "scott.marlowe"
Date:
Subject: Re: Error message using pg_dump with tar format