> -----Original Message----- > From: Matt Adams [mailto:[EMAIL PROTECTED] > Sent: Monday, April 19, 2004 2:25 PM > To: [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
