Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Pervasive database migration/upgrade

Posted on 2014-10-31
2
Medium Priority
?
220 Views
Last Modified: 2014-10-31
Hi

We're having a lot of issues with a couple of our psql servers and are going to upgrade.

Current:  Windows 2003 standard x86, v9.x psql

New:  Windows 2008 standard x64, v11.x psql

Both environments are virtual on vmware ESXi 5.1.  My plan for migration is to shut down the old servers, detach the data drive, and attach it to the new server.

My question is:  Can the new psql just attach this database as is or would it be a better plan to attach the old data drive and a same size new data drive and do some kind of import activity?

Thanks!

Tony
0
Comment
Question by:tonyjoewalker
2 Comments
 
LVL 28

Accepted Solution

by:
Bill Bach earned 2000 total points
ID: 40415516
The PSQL environment uses the data files only, and won't care if you just move the data volume to the new server.

However, you may wish to research performance issues due to "disk alignment" problems. Your older volumes from Server 2003 are likely misaligned, and this can slow things down, further hurting performance. For best results, I'd recommend moving the data to a new volume. You may wish to try running Microsoft's SQLIO to test the current volume, as well as a newly-created 2008 volume, and make your decision based on the results.
0
 

Author Closing Comment

by:tonyjoewalker
ID: 40415567
Thank you!  that is exactly what I was looking for!
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question