Skip site navigation (1) Skip section navigation (2)

Re: migration of 7.4 to 8.1

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql-performance Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: migration of 7.4 to 8.1
Date: 2008-03-12 14:46:25
Message-ID: 73D9E34A-EBA1-4D1B-877C-4583042EDD6F@khera.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Mar 12, 2008, at 2:43 AM, sathiya psql wrote:

> My question is that how to migrate my database to 7.4 to 8.1
>
>
> that is not only dumping the db and extracting that in 8.1 ..
>
> If i do that whether it will work without problem, or i have to do  
> some manual changes is my question...

the pg dump/restore should work without issue.  you might not get all  
the relations of which sequence is "owned" by which table, and similar  
for foreign keys, but you may not miss that much.

then, review *every* SQL query you run and make sure it runs against  
8.1.  things that will trap you are treating strings as integers in  
certain cases.  most everything else should just work.  you will also  
want to review the performance of each query.

you can find a detailed list of changes to the DB in the release notes  
file that comes with every release.

finally, this is not really a performance issue, so perhaps the pg- 
general list would have been better to ask your question.


In response to

pgsql-performance by date

Next:From: Enrico SirolaDate: 2008-03-12 15:25:29
Subject: 8.3 write performance
Previous:From: Heikki LinnakangasDate: 2008-03-12 13:43:46
Subject: Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group