Solved

Pervasive database migration/upgrade

Posted on 2014-10-31
2
217 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

738 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