Postgres Pro
Downloads
Home   >   mailing lists

pg_dump cross-version support - Mailing list pgsql-general

From Alain BAUDHUIN
Subject pg_dump cross-version support
Date
Msg-id 000001c64aea$b2988320$6300a8c0@SERVEUR1
Whole thread Raw
Responses Re: pg_dump cross-version support  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view
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
 

pgsql-general by date:

Previous
From: "Rushabh Doshi"
Date:
Subject: db sever seems to be dropping connections
Next
From: "Alex bahdushka"
Date:
Subject: PANIC: heap_update_redo: no block