> -----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.