asked on

Postgre database server.

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.

Dan Craciun

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

MohammadKhan

ASKER

Will I be able to setup RAID on Hyper-V and from where can I get Hyper-V server OS.

Dan Craciun

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.

MohammadKhan

ASKER

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.

ASKER CERTIFIED SOLUTION

Dan Craciun

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial