Solved

Pervasive database migration/upgrade

Posted on 2014-10-31
2
215 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 500 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

809 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