I'm just trying to upgrade from 6.4 to 7.1 and did a
pg_dumpall -oz > outfile
or
pg_dump -oz database > outfile
to catch the permissions, and I get a Segmentation fault. Omitting -z works, but that
doesn't cut the mustard cuz I'd have to add all the permission by hand for every single
table (only a few dozen but still . . . ).
Can you dump the grant/revoke commands separately somehow (which table are they in?) or is
there another solution?
Cheers Frank