Rich Cullingford <rculling@sysd.com> writes:
> Hmmm, how do you use 7.4 utilities against a 7.3 DB?
pg_dump can dump from prior-release DBs (back to 7.0 at the moment).
Just point it at the older DB's port.
This is a bit tricky when installing from RPMs, since there's no really
easy way to install just pg_dump and libpq without overwriting your old
server executable, which you don't want to do just yet.
> I'm assuming that you don't mean:
> --superuser=username
> which seems to be for disabling triggers, but perhaps the following as a
> parameter to pg_dumpall:
> --use-set-session-authorization
Yeah, the latter is really the important part I think. In 7.4 that is
the default (and only) behavior, but you can get it in 7.3 by using the
switch. So the 7.3 pg_dump should be good enough for this purpose.
regards, tom lane