| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Pete Wall <Pete_Wall(at)symantec(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Downgrades |
| Date: | 2013-04-05 23:35:45 |
| Message-ID: | 515F5FD1.7030200@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Steve Crawford | 2013-04-05 23:47:31 | Re: PostgreSQL Downgrades |
| Previous Message | John R Pierce | 2013-04-05 22:46:43 | Re: PostgreSQL Downgrades |