Re: problem with dumpall - Mailing list pgsql-admin

From Weiping He
Subject Re: problem with dumpall
Date
Msg-id 00cf01c199a2$fa8841f0$d20101c0@T21laser
Whole thread Raw
In response to problem with dumpall  (RED <kv@red.kht.ru>)
Responses Re: problem with dumpall
List pgsql-admin
> Hi !
> I have small problem
> amount size all databases ~5Gb
> I make dumpall >dumpfile
> when size dumpfile = 1024 dumpall print error and exit !
> Linux Slackware7.2 ext2 2.4.17 gcc2.95
                                   ^^^
I think ext2 can't support file larger then 2G,
and your DB may be near 5Gb, so it's a problem.
take a look at:

http://www.postgresql.org/idocs/index.php?backup.html#BACKUP-DUMP-LARGE

or change to some journal filesystem like reiserfs would help.

    regards    laser


pgsql-admin by date:

Previous
From: "Florian Helmberger"
Date:
Subject: Re: pgdumpall_file is bigger than 2 Gigabyte
Next
From: "Timur V. Irmatov"
Date:
Subject: Re: problem with dumpall