Hello!
I need to load a pgsql 8.1 database dump (SQL format) into a pgsql 7.3
server (through phpPgAdmin). This does not work, since many v8 instructions
are not recognised by v7.3 (e.g. SET default_table_space, function
pg_get_serial_sequence,...) which is not unexpected.
I'm surprised, though not to find any pg_dump switch to produce a v7.x
compatible dump. Did I look at the wrong place ? Does anybody know about the
right way to dump a database in a cross-version compatible form ?
Any hint is welcome!
A.
NB: I expect this issue is fairly common for people who, like me, run their
development server on Windows (ie. v 8+) and have their application hosted
at a provider who keeps delaying its upgrade from v7 to v8...
_____________________
Alain BAUDHUIN
alain(dot)baudhuin(at)swing(dot)be