Re: Downgrading from Postgresql 7.4 to 7.1 - Mailing list pgsql-general

From Dann Corbit
Subject Re: Downgrading from Postgresql 7.4 to 7.1
Date
Msg-id D90A5A6C612A39408103E6ECDD77B8299CAA0D@voyager.corporate.connx.com
Whole thread Raw
In response to Downgrading from Postgresql 7.4 to 7.1  (Matt Adams <matt.adams@mercyships.org>)
List pgsql-general
> -----Original Message-----
> From: Matt Adams [mailto:matt.adams@mercyships.org]
> Sent: Monday, April 19, 2004 2:25 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Downgrading from Postgresql 7.4 to 7.1
>
>
> Hello:
>
> I have an awkward situation where I must downgrade from 7.4
> to 7.1.  I
> have two databases already in 7.4.  I'm largely ignorant concerning
> postgresql: am I going to have any severe problems downgrading?

Just dump and load.  It is a very simple procedure.  One possibility
would be as follows -->

From 7.4:
pg_dump -c -C -D -f output.sql -h localhost
<your_database_name_goes_here>

Into 7.1:
psql -h localhost -f output.sql template1

If you are using features that are available in 7.4 and not available in
7.1 then you may have problems.

pgsql-general by date:

Previous
From: "Froggy / Froggy Corp."
Date:
Subject: PL/SQL question
Next
From: Janning Vygen
Date:
Subject: Re: convert result to uppercase