From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Robert Fitzpatrick" <robert(at)webtent(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Pg_dumpall from different versions |
Date: | 2003-06-10 05:34:30 |
Message-ID: | 29939.1055223270@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Robert Fitzpatrick" <robert(at)webtent(dot)com> writes:
> 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
Yeah :-(. pg_dump should work, but pg_dumpall uses LEFT JOIN in its
query to get pg_database entries.
CVS tip's pg_dumpall actually works (in my testing at least) with
servers back to 7.0, but this is the first time this has ever been
true. Up till recently, pg_dumpall was a simple shell script and making
it cope with different server variants seemed impractical. As of 7.3
pg_dumpall is a real C program, but incorporating logic in it to issue
valid queries to older servers only happened in the last couple weeks.
Your best bet might be to grab pg_dumpall.c from CVS tip and try to
build it in your 7.3 installation --- I think that will work, but have
not tried it. If you don't want to do that, you should be able to use
your 7.3 pg_dump to dump each 7.0 database individually, but you'll need
to do something manual to dump your user and group definitions.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | culley harrelson | 2003-06-10 05:57:18 | tsearch v2 |
Previous Message | Shridhar Daithankar | 2003-06-10 05:32:42 | Re: Trouble to understand plain of postgresql |