PostgreSQL is a powerful, open source object-relational database system that's been under active development for over 15 years. An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL has a SQL implementation that strongly conforms to the ANSI-SQL 92/99 standards. It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels. This JumpBox includes PostgreSQL 8 along with PHPPgAdmin setup and ready to run. The PostgreSQL server is network accessible and provides a great storage engine for a broad array of applications.
Benefits of running a JumpBoxDeploying an application as a JumpBox provides a dramatically-reduced path to getting started with the software. Aside from installation benefits it yields other advantages such as portability across computing environments and simplified ongoing maintenance of the application. Here are a few of the benefits to using a JumpBox:
- Self-contained deployment means easy to move or delete - it won't scatter files all over your operating system.
- New versions of the JumpBox contain updates to each component in the software stack so there's no patching web servers, application servers, databases, dependencies, etc.
- A web-based administration console simplifies the management of your application including SSL certs, email relaying, SSH, backups and more.
- Once you know how to install a JumpBox you can deploy any of 50+ other JumpBoxes and take advantage of a growing library of conveniently-packaged Open Source software.
- Xen Open Source
- Microsoft Virtual Server
- Microsoft Virtual PC
- Virtual Iron
No limitations. This is a fully-functional, free JumpBox.