It's basically a educational situation: We've got a Intel Celeron 2.5Ghz / 512 MB RAM / >40GB Hard Drive. We need to set up a basic SQL server for 5~15 LAN users with a >1GB database.
I can use debian, fedora, freeBSD, mandrake, opensuse, redhat, slackware, suse or ubuntu with firebird, mysql or postgreSQL.
[btw: it's a corporate decision, I can't pick anything else besides the one listed. What I can do is ask for support for another software - This is something that looks interesting since I believe that MariaDB w/ Slackware would be the best choice)
I basically need the most lightweight solution possible.
I'm thinking about Slackware with PostgreSQL, but I was wondering which one would be less dependent on hardware specs and easiest to manage, the traffic flow itself won't be very high but the database will have to up for tests for at least a semester or two before we can apply for a dedicated server..
I recommend debian with mysql.
Debian because its a very widespread system for severs and you get tons of documentation so its easy to setup and maintain.
mysql because its simple and well documented.