Solved

Postgre database server.

Posted on 2014-03-24
5
121 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

by Nathan Brom/Bromy2004 Introduction There are numerous websites out there for any different type of program you can imagine.  Of those, you'll need to decide which ones are legitimate and aren't trying to steal your money or infect your comput…
This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

911 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

25 Experts available now in Live!

Get 1:1 Help Now