I have versions 7.4 (port=5433) & 8.2 (port=5432) on this Ubuntu box.
I want to use v8.2's pg_dumpall to export v7.4's data into a text file.
(IDEALLY I'd like to port it directly to psql and avoid the file, but I don't know if I can do that.)
Anyway, when I:
prompt:/usr/lib/postgresql/8.2/bin$ ./pg_dumpall -c -v -p 5433 > myfile.txt
It's NOT dumping everything. Only... Well, I'm not sure.
I think only DB postgres. It's only 87 lines long.
Anybody have any suggestions?
Thank you,
Ralph Smith
=====================