| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jason Tan Boon Teck <tanboonteck(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Downgrading v8.4 database to v8.3 |
| Date: | 2010-05-05 15:58:07 |
| Message-ID: | 4BE1958F.8050708@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Jason Tan Boon Teck wrote:
> I need to move some databases written in Psql v8.4 to the stable
> production server running v8.3. I tried pg_dump and pg_restore as well
> as PgAdmin3. I am unable to do so due to the backward
> incompatibility. Is there anyway to do this?
>
You can try connecting a 8.3 client to the 8.4 server, then running
pg_dump from that 8.3 client. That's a common approach for
dump/restore when moving forward a version, and it may resolve your
issue when moving backward one too. The 8.3 client shouldn't dump
anything the 8.3 server doesn't know how to restore.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-05-05 16:05:21 | Re: Downgrading v8.4 database to v8.3 |
| Previous Message | Jason Tan Boon Teck | 2010-05-05 15:48:02 | Downgrading v8.4 database to v8.3 |