On Mon, 2005-07-25 at 22:02, Tom Lane wrote: > Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> writes: > > On Mon, 2005-07-25 at 16:56, Martijn van Oosterhout wrote: > >> pg_dump should be able to dump any older version. It's a bug otherwise. > > > But FYI that backwards compatibility was introduced around 7.3 or 7.4 > > version. Before that you'd have issues. I know from experience that V > > 7.2 pg_dump / pg_dumpall had issues with 7.0 and / or 7.1 or something > > like that. Not sure the exact versions. > > pg_dump believes it can dump from any server back to 7.0; if it can't, > that's a bug, and details would be appreciated. > > Note however that the *output* of pg_dump is not guaranteed to load into > a server older than the pg_dump's own version. I thought the backwards dumping compatibility thing was fairly new (i.e. it showed up around 7.3 or 7.4) and before that, if you used, say pg_dump from 7.1 to try and dump from 6.5 you'd get errors. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend