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? |