Create a PostgreSQL appliance

Registered by Alon Swartz

PostgreSQL is a fully featured object-relational database management system. It supports a large part of the SQL standard and is designed to be extensible by users in many aspects. Some of the features are: ACID transactions, foreign keys, views, sequences, subqueries, triggers, user-defined types and functions, outer joins, multiversion concurrency control.

It makes a lot of sense to segregate a database on a separate machine / appliance.
Separating different components into different machines makes it easier to monitor load and do resource re-allocation in a VM (e.g., increase memory, add CPU, etc.)

Notes:
* the database server will have to be accessible via TCP by default
* possibly implement phpPGAdmin for easy administration
* include webmin firewall module (configure who can access the system/database)

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
Alon Swartz
Definition:
Approved
Series goal:
Accepted for 2009.02-hardy-x86
Implementation:
Implemented
Milestone target:
None
Started by
Alon Swartz
Completed by
Alon Swartz

Related branches

Sprints

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.