1) We will be running 2 x Postgresql db in the machine.
2) Total number of connections to be around 100. The connections from the clients machines will be in ODBC and socket connections.
3) Estimated number of transactions to be written into the Postgresql db is around 15000 records per day.
Assuming this server will be dedicated to PostgreSQL only, the needs outlined above are modest.
As was pointed out in other posts, a simple sub-ghz machine with 512mb of ram is more than enough, but I'd slap on a gig only because RAM is cheaper now. If the database on this server is crucial, I'd look at setting up a UPS, RAID (at this level, even software-based RAID will do fine, RAID 5 preferably) and investing in a backup/replicator solution.
-- Best, Al Hulaton | Sr. Account Engineer | Command Prompt, Inc. 503.667.4564 | [EMAIL PROTECTED] Home of Mammoth Replicator for PostgreSQL Managed PostgreSQL, Linux services and consulting Read and Search O'Reilly's 'Practical PostgreSQL' at http://www.commandprompt.com
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
