Re: [ADMIN] large database: problems with pg_dump and pg_restore

[lst_hoe02]

Zitat von Martin Povolny <martin.povo...@solnet.cz>:

Hallo,


dump).


make a dump in the default 'tar' format. I got this message:

pg_dump: [tar archiver] archive member too large for tar format

I have some quite grave problems with dumping and restoring large databases (>4GB of I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping: I was unable to

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



Regards

Andreas

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

smime.p7s
Description: S/MIME Cryptographic Signature