Re: large database: problems with pg_dump and pg_restore - Mailing list pgsql-admin

From lst_hoe02@kwsoft.de
Subject Re: large database: problems with pg_dump and pg_restore
Date
Msg-id 20101026213147.1040158mc9k2bgyo@webmail.kwsoft.de
Whole thread Raw
In response to large database: problems with pg_dump and pg_restore  (Martin Povolny <martin.povolny@solnet.cz>)
List pgsql-admin
Zitat von Martin Povolny <martin.povolny@solnet.cz>:

> 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

pgsql-admin by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: postgres 8.4.5 jdbc is 8.4-701.jdbc3
Next
From: Samuel Stearns
Date:
Subject: Re: large database: problems with pg_dump and pg_restore