Postgres Pro
Downloads
Home   >   mailing lists

Pg_dumpall from different versions - Mailing list pgsql-general

From Robert Fitzpatrick
Subject Pg_dumpall from different versions
Date
Msg-id 003601c32ec2$07911e70$0b01a8c0@columbus
Whole thread Raw
Responses Re: Pg_dumpall from different versions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Nulls get converted to 0 problem
Next
From: "Jeffrey W. Baker"
Date:
Subject: Thousands of semops for every i/o