Re: Downgrading from Postgresql 7.4 to 7.1

> -----Original Message-----
> From: Matt Adams [mailto:matt(dot)adams(at)mercyships(dot)org]
> Sent: Monday, April 19, 2004 2:25 PM
> To: pgsql-general(at)postgresql(dot)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.