On 2009-07-05, Steve Purcell <st...@sanityinc.com> wrote: > Thanks for the quick reply, Tom. That makes sense, and yes, that does > appear to be the problem. > > I thought that I *was* using the newer pg_dump, but I'm doing this on > Debian: > > # su - postgres -c "env PGCLUSTER=8.3/main pg_dump openx|env > PGCLUSTER=8.4/main pg_restore -d template1 -C" > > And the debian pg_wrapper script ends up selecting the 8.3 pg_dump > binary in the first case. I'll have to figure out if there's even a > way to execute the newer pg_dump against the old database, which I > expect to be fiddly.
easiest is to bypass pg_wrapper /usr/lib/postgresql/8.4/bin/pg_dump -p 5432 I have raised this with debian. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
