> So the OS doesn't get a table over 2 gigs. Does anyone have a table
> that dumps a flat file over 2gig's, whose OS can't support files over 2
> gigs. Never heard of a complaint.
>
Probably because people dump to tape or pipes, that compress the dump
with gzip and split it with split -b ? That is what I would do with my
backups:
pg_dump | gzip --fast | split -b512m - backup.monday.gz.
Andreas