Re: large database: problems with pg_dump and pg_restore

From: lst_hoe02(at)kwsoft(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: large database: problems with pg_dump and pg_restore
Date: 2010-10-26 19:31:47
Message-ID: 20101026213147.1040158mc9k2bgyo@webmail.kwsoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Zitat von Martin Povolny <martin(dot)povolny(at)solnet(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Samuel Stearns 2010-10-26 21:51:25 Re: large database: problems with pg_dump and pg_restore
Previous Message Vibhor Kumar 2010-10-26 15:51:57 Re: postgres 8.4.5 jdbc is 8.4-701.jdbc3