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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster