Hello,

I would like an opinion what Linux to choose with GUI with PostgreSQL database for server.
Oracle Linux or Ubuntu?

Thanks for any help,
Asaf

You should pay Oracle as little money as possible. They seem to be trying to prove that MS were pikers when it came to vertical integration and gouging folks on licenses. They also like to do software audits on folks doing business with them. In my opinion there is no reason to use Oracle for Postgres or anything you don't need to and many reasons not to tie yourself to that organization.

If you're considering Oracle Enterprise Linux (OEL) however, I'd suggest using RedHat Enterprise Linux (RHEL) 6 which is what OEL is forked from and many commercial applications are written to run on that. If you want one you don't have to pay for subscriptions and don't need commercial support for I'd suggest CentOS 6 which is a binary compile from RHEL source.

We run Postgres quite well on both RHEL5 and RHEL6 so it should run just as well on CentOS5 & CentOS6. (You should go with 6 rather than 5 simply because 5 is quite long in the tooth these days.)

Ubuntu is derived from Debian which isn't the same family as the RedHat/RHEL/OEL/CentOS/Fedora stuff. Lots of folks use it but lots of folks hate it too. If you're familiar with it and enjoy it there's no reason not to use it for Postgres.

Thanks for your help.