Solved

Postgre database server.

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Installing OS on Poweredge 2800 Raid 1 97 56
VPN does not work after installing Hyper-V in Win 8.1 PRO 8 99
GPO not applied 4 73
URL to download Windows 10 Home 2 148
This article covers how to install the Microsoft Windows Operating System (OS). What is covered in this article:  > Different Versions and Editions of the Windows OS  > Upgrading versus Fresh Installation of the OS           - Steps to take pr…
Many admins will agree: WSUS is is a nice invention but using it on the client side when updating a newly installed computer is still time consuming as you have to do several reboots and furthermore, the procedure of installing updates, rebooting an…
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…
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…

786 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