hi fred,
i ran into the same problem a couple of weeks ago and realized that the
problem was where the dump was being put instead of trying to deal with
the size of the file.
go ahead and do type 'df' at the command prompt and look at the space
allocated to your partitions. do the database dump accordingly. i.e. i
found out that /var/tmp was the perfect place to spit out my dbdump.txt
file.
good luck!
tuna
On Tue, 2002-03-19 at 16:39, Fred Moyer wrote:
> hey fellow pg'ers.
>
> ran time pg_dump -c --verbose database > datafile.psql from the command line
> and got a file size limit exceeded. datafile.psql stopped at 2 gigs. any
> ideas how to exceed that limit?
>
> redhat 7.2, 2.4.9-31 kernel
> postgres 7.2
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)