LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Virtualization and Cloud
User Name
Password
Linux - Virtualization and Cloud This forum is for the discussion of all topics relating to Linux Virtualization and Linux Cloud platforms. Xen, KVM, OpenVZ, VirtualBox, VMware, Linux-VServer and all other Linux Virtualization platforms are welcome. OpenStack, CloudStack, ownCloud, Cloud Foundry, Eucalyptus, Nimbus, OpenNebula and all other Linux Cloud platforms are welcome. Note that questions relating solely to non-Linux OS's should be asked in the General forum.

Notices


Reply
  Search this Thread
Old 01-17-2011, 08:36 AM   #1
tirab
Member
 
Registered: Dec 2010
Location: Italy, Lucca
Distribution: Slackware
Posts: 39

Rep: Reputation: 4
Using postgres on kvm virtual server


Hello,

I'm planning to virtualize one of my production servers. It has postgres 8.2, and I would know if someone had experience of running postgres on a virtual server.

Regards.
 
Old 01-17-2011, 10:43 AM   #2
steve_dupuis
LQ Newbie
 
Registered: Dec 2008
Location: Ottawa, Canada
Distribution: Arch, Sparky, BlackArch, lots of VMs
Posts: 9

Rep: Reputation: 0
I've been using the Oracle Sun version of Virtualbox quite successfully. It allows proper allocation of USB devices, networking, video and sound - not important if you are going to create a postgres database server.

I suggest you check these sites for more information (and search their forums):

http://www.linux-kvm.org/page/Main_Page
http://www.virtualbox.org
http://www.postgresql.org

Regards,
Steve Dupuis
Ottawa, Canada
 
Old 01-18-2011, 04:11 PM   #3
dyasny
Member
 
Registered: Dec 2007
Location: Canada
Distribution: RHEL,Fedora
Posts: 995

Rep: Reputation: 115Reputation: 115
1. I have been running MSSQL and MSJET (Exchange and AD) in production for a while now, on KVM machines - no problem.
2. I know of several Oracle production setups on top of KVM - again, stable all the way
3. I have seen quite a few LAMP hosts on KVM, so MySQL seems to be working OK as well
4. No personal experience with PG, but what I would do to make it work is as follows:

A stable Enterprise-class Linux distro as the platform (yes, I'd go for RHEL)
VirtIO drivers for disk and network
Virtual disk image residing on a fast and reliable storage (RAID10 LUN, on a well maintained SAN would be best, but that costs)
Virtual disk image should not be using any of QEMU's caching options, meaning use cache=none. Slightly slower, but much safer for heavily utilised v-disk
Unless you absolutely must use v-disk snapshots, stick to RAW disks, not qcow2 - there's a bit of performance penalty, if you want the extra features.
Provide the VM with multiple v-CPUs and enough RAM

Oh, and if you can stress-test the thing in a test host and VM before you go into production, that would be best.

Hope _this_ helps.
 
1 members found this post helpful.
Old 01-26-2011, 06:48 AM   #4
tirab
Member
 
Registered: Dec 2010
Location: Italy, Lucca
Distribution: Slackware
Posts: 39

Original Poster
Rep: Reputation: 4
Quote:
Originally Posted by dyasny View Post
1. I have been running MSSQL and MSJET (Exchange and AD) in production for a while now, on KVM machines - no problem.
2. I know of several Oracle production setups on top of KVM - again, stable all the way
3. I have seen quite a few LAMP hosts on KVM, so MySQL seems to be working OK as well
4. No personal experience with PG, but what I would do to make it work is as follows:
Thanks for you information and suggestion.

I'm working on a test server with slackware linux (this is the distro we are using for all of our servers).

Following your suggestion I'll try also using VirtIO drivers and no cache.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
kvm only shows virtual cpu!? cosmonate Linux - Virtualization and Cloud 10 02-02-2011 10:38 AM
Read guest virtual memory in KVM raghu2383 Linux - Virtualization and Cloud 0 11-29-2010 05:08 AM
LXer: Create a KVM-based virtual server in 3 steps LXer Syndicated Linux News 0 01-21-2010 03:00 PM
Virtual Interfaces, Bridging, TUN, TAP question for KVM setup (ubuntu server 9.04) mogga Linux - Networking 0 06-22-2009 02:35 AM
KVM Virtual Machine CD CHANGE ashishverma1984 Fedora 2 12-12-2008 03:51 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Virtualization and Cloud

All times are GMT -5. The time now is 10:39 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration