| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, Chris Bowlby <excalibur(at)hub(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_restore woes.. |
| Date: | 2003-01-03 00:47:03 |
| Message-ID: | 5634.1041554823@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
>> Lamar Owen wrote:
>>> I can't believe that's the best advice, given that the migration from 7.2 to
>>> 7.3 isn't the easiest one on the world.
> But you can use the 7.3 pg_dump against older servers, so you can
> probably upgrade only pg_dump and keep 7.2 for the rest.
No, because 7.3 pg_dump's output probably won't load into an older
server. (For example, it'll likely try to use ALTER TABLE ADD PRIMARY
KEY which didn't work before 7.3. Similar issues occur in every prior
release AFAIR.) The input-version flexibility in pg_dump is really only
useful in an I'm-upgrading-now scenario.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-01-03 02:03:48 | Re: ODBC - adding missing FROM clause entry |
| Previous Message | Medi Montaseri | 2003-01-03 00:45:37 | What is best way to query presence of a table |