From: | Pete Wall <Pete_Wall(at)symantec(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL Downgrades |
Date: | 2013-04-08 13:41:10 |
Message-ID: | CD8832CA.185AC%pete_wall@symantec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It was the data changes I was concerned about: Any
additions/deletions/modifications done on the database while it's using
the 9.x binaries that should be brought back if we downgrade to the 8.x
version.
I think the only way would be to "manually" dump the data using custom
psql commands instead of using pg_dump/pg_dumpall.
Thanks, Adrian.
On 4/5/13 6:35 PM, "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com> wrote:
>On 04/05/2013 03:33 PM, Pete Wall wrote:
>> Is it possible to downgrade PostgreSQL by a major version?
>>
>> If I want to upgrade a PG database from 8.x to 9.x, I have to dump the
>> db, install the new binaries and import the dump file. This works fine
>> going forward, but what if I need to rollback my changes? I cannot dump
>> the 9.x database and import it with 8.x binaries, because the 9.x dump
>> contains keywords that the old binaries don't understand (e.g.
>>REPLICATION).
>>
>> I could import the original 8.x dump file again, but then I've lost any
>> changes made when using the new binaries.
>
>What changes, data/schema or both?
>
>>
>> Is there a supported way to downgrade PostgreSQL by major versions?
>
>Not that I know of.
>
>>
>> Thank you,
>> -Pete
>
>
>--
>Adrian Klaver
>adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Harley | 2013-04-08 13:45:31 | Re: Selecting timestamp from Database |
Previous Message | Adrian Klaver | 2013-04-08 13:36:39 | Re: Selecting timestamp from Database |