PostgreSQL Consultancy


With over 5 years of PostgreSQL experience, Transitiv Technologies are able to provide you with a range of PostgreSQL related services, including:

  • Remote PostgreSQL DBA
  • Performance investigations and tuning
  • Clustering, High Availability and Replication
  • PostgreSQL database design and development
  • PostgreSQL Monitoring
  • Migrating from MySQL to PostgreSQL
  • Upgrading PostgreSQL
  • Training / Mentoring

We can assist you throughout the entire database lifecycle, from design to tuning. Contact us now to discuss how we can help you.

Clustering, High Availability and Replication

Transitiv can help you design and implement High Availability and Replication solutions for your critical PostgreSQL databases. Using various open source technologies, including: PostgreSQL Streaming Replication, DRBD, Londisite and Pacemaker to create available and durable solutions. PostgreSQL's Streaming Replication offers a mature and robust solution for replicating data between two PostgreSQL servers, ensuring you don't loose important data. PostgreSQL's hot standby functionality allows the slave PostgreSQL server to take over at a moments notice or be used to scale.

Database Design and Development

Transitiv has extensive experience of database design and development with PostgreSQL. We can offer you advice over schema design and can assist you during development.

Scaling

Transitiv has experience in scaling PostgreSQL systems using a range of techniques. Replication combined with load balancing is a simple and effective method of scaling PostgreSQL in read heavy environments. For more complex environments PL/Proxy can be used to provide vertical and horizontal scaling of applications.

Monitoring

With our expert knowledge of both PostgreSQL and Nagios, Transitiv are well placed to assist you in monitoring your PostgreSQL servers. We have developed a number of Nagios checks for monitoring replication and more.

Migration and Upgrading

Is your current database limiting your business, lacking features, not cost effective. Transitiv can help you migrate to PostgreSQL.

Performance

Transitiv can help investigate any PostgreSQL performance issues you have and with our experience help you tune PostgreSQL for your particular environment.

Contact us to discuss your PostgreSQL requirements.

Open Source Services from Transitiv Technologies

About PostgreSQL

PostgreSQL is an enterprise grade open source object-relational database system. It has a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

It 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/optimiser, and write ahead logging for fault tolerance.

PostgreSQL is the worlds most advanced open source relational database, providing an excellent balance of features and data integrity. It has a strong and growing community around it with many extensions available complementing PostgreSQL's core strengths for specific use cases. It can run on most platforms including Linux, Unix, BSD, Mac OSX and Windows.

Contact us to find out more about our PostgreSQL support and our professional consultancy service for Postgres.