PostgreSQL

Redpill Linpro provides a range of services around PostgreSQL, from support and reviews to design, tuning, training and fully managed hosting.

PostgreSQL combines the stability and reliability of traditional relational database management system (RDBMS) with low cost and high rate of development and innovation from the open source model to provide a powerful and cost-efficient solution for almost every database need.

Like most traditional databases, the first priority for PostgreSQL is safety and data integrity. Full transactional protection of all operations - including fully transactional DDL - is a basic feature underlying the entire system.

Designed to scale to large installations, not only from a technical perspective but also for management, it is ideal for large deployments, both traditional and in the cloud. By providing all management interfaces fully open, PostgreSQL integrates well with existing monitoring systems, such as Nagios, Munin, op5 and many more.

Providing standards SQL based interfaces through layers like JDBC and ODBC, PostgreSQL works with most major business intelligence products on the market for advanced and custom data analytics.

Powerful query engine

PostgreSQL has an advanced, fully cost-based optimiser capable of executing highly complex queries at high performance and concurrency. Capabilities like unlimited subselects, VIEWs, recursive queries and advanced analytical window aggregates are standard features. If this is not enough, the query executor can be extended using custom stored procedures both in database native SQL and PL/pgsql languages as well as in most common scripting languages, such as Perl, Python and Tcl.

High availability

For mission critical requirements, PostgreSQL provides several ways of achieving high availability. On top of the standard ability to perform Point In Time Recovery, PostgreSQL comes with support for all major clustering solutions and provides many different technologies for replication, data sharding, and load distribution.

Extensively extensible

Following the principles of open source, PostgreSQL comes with almost unlimited abilities for extensions.

Third-party products, open or proprietary, can extend and replace the core system functionality under the same rules as built-in functionality. With the open model not playing favourites to functionality from the same vendor, it is possible to pick the technology that fits best for each use case and put them together. One example of this includes the advanced geospatial functionality provided by PostGIS.

Securing your data

PostgreSQL supports security at every level - from SSL-encrypted connections to full role-based permissions on all objects in the system, as well as integration with many enterprise authentication systems, such as LDAP, Kerberos, RADIUS and SSL PKI certificates.

Permissive Open Source

PostgreSQL is licensed under a BSD-style permissive license. This license has no follow-on ”viral” effects, nor any restrictions on usage or deployments - no more counting cores!

Community powered

PostgreSQL is one of the the largest pure open source projects in the world, and completely vendor independent. The active developer community consists of representatives from many different companies all over the world, including Red Hat, NTT and Skype, all working together to improve the product, thus exploiting the true power of the open development model. This has also spawned a vibrant ecosystem of support and service companies, including Redpill Linpro.