Re: large database: problems with pg_dump and pg_restore

[lst_hoe02@xxxxxxxxx]

Zitat von Martin Povolny <martin.povolny@xxxxxxxxx>:

> Hallo,
>
> I have some quite grave problems with dumping and restoring large  
> databases (>4GB of
> dump).
>
> I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping:  
> I was unable to
> make a dump in the default 'tar' format. I got this message:
>
> pg_dump: [tar archiver] archive member too large for tar format

It looks like "tar" is limited to 4GB on your OS...

Try to use "split" to split up the dump to something which your  
OS/Tools can reliable handle.

Regards

Andreas

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature