Pg_dumpall from different versions

From: "Robert Fitzpatrick" <robert(at)webtent(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Pg_dumpall from different versions
Date: 2003-06-09 20:02:12
Message-ID: 003601c32ec2$07911e70$0b01a8c0@columbus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I try to use the pg_dumpall from a 7.3.3 server to dump data from a
7.0.2 server, I get the following error:

pg_dumpall: query failed: ERROR: OUTER JOIN is not yet supported

Then I tried just copying the pg_dumpall from the 7.0.2 server onto the
7.3.3 server and trying to use that binary instead, but I get this
error:

psql: FATAL: user "root" does not exist

What are my options for doing a dumpall from a 7.3.3 server to dump the
data from the 7.0.2 server?

--
Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cristian Custodio 2003-06-09 21:57:23 Trouble to understand plain of postgresql
Previous Message Fernando Papa 2003-06-09 19:48:10 Strange result with select/not null/OR