Solved

Postgre database server.

Posted on 2014-03-24
5
127 Views
Last Modified: 2014-04-16
In my office of 20 users, I am running postgre database server on Windows 2003 server standard edition. Network setup is peer to peer with no  domain or active directory. Now my server is getting old and I am thinking of replacing it with a faster server. Can I use any other OS to host Postgre database?
Reason I like Windows server is its stability and ability to have hardware RAID. If I am going to use any other operating system, it should have those two features. Plus it has be cheaper than Windows Server 2008 or 2012.
0
Comment
Question by:MohammadKhan
[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
  • 3
  • 2
5 Comments
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39951590
I'm running Postgres on a CentOS 6.5 VM. 30 users, no performance issues.
The host is Windows Server 2012, but you can also use the free Hyper-V Server 2012.

HTH,
Dan
0
 

Author Comment

by:MohammadKhan
ID: 39951666
Will I be able to setup RAID on Hyper-V and from where can I get Hyper-V server OS.
0
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39951681
http://technet.microsoft.com/en-US/evalcenter/dn205299.aspx

You can use the server's physical RAID card to build your arrays. If you need software RAID I think you'll need a full version of Windows Server.

But, if you're not afraid of Linux, you can install CentOS, Debian etc directly on the server and use the software RAID from Linux.
0
 

Author Comment

by:MohammadKhan
ID: 39954884
I am not comfortable with Linux, plus Linux costs about the same as Windows server 2012. After reading about different server OS and cost comparison , I am leaning more towards Windows 2012 server essentials. Will that work well as Postgres server? I only have 20 users that connect to the database server through workstations that run Windows XP, Windows 2007 and 2008.
0
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 260 total points
ID: 39955100
It should work. Since Postgres is not Microsoft software, I don't think the 25 users limit applies to it.

I would still run Postgres as a virtual machine (if you buy Server Essentials you have the right to install it both on a physical and a virtual server) for the convenience. Next time you want to upgrade your server, you just copy the VM.

PS: since I only work with small clients (under 100 PCs), I never bought an enterprise version of Linux (RedHat or SUSE), so I never paid for Linux. My personal favorite is CentOS for servers. Old, but stable packages.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Preface Having the need * to contact many different companies with different infrastructures * do remote maintenance in their network required us to implement a more flexible routing solution. As RAS, PPTP, L2TP and VPN Client connections are no…
Many times while working on a computer regardless of any Operating System, lag and crashes seem to creep in, hindering your working speed. Sometimes, it can also cause your work to be lost unexpectedly and as a result, you are unable to meet your de…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

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