Solved

Postgre database server.

Posted on 2014-03-24
5
119 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
  • 3
  • 2
5 Comments
 
LVL 34

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 34

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 34

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article describes how to set permissions to allow a limited-permissions user to start and stop a particular System Service.   It is always best to give users only the permissions that they need to perform their job, so tweaking particular permi…
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now