Thread: 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?


Thanks

Matt
--
Matt Adams <matt.adams@meryships.org> voice +1 (903) 939-7641
Systems Engineer, Mercy Ships IOC <http://www.mercyships.org/>

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