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