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
