PostgreSQL Focus

PostgreSQL is a powerful, open source relational database system. Over 20 years of solid development and mission-critical deployments have earned its reputation as the most advanced open source database in the world.

Why PostgreSQL?

Developers use PostgreSQL to drive complex, vital applications. Advanced features enable this technology to capably power both OLTP (online transaction processing) and OLAP (online analytical processing) applications.

  • PostgreSQL is proven, stable, and has a healthy, controlled product roadmap.
  • The technology is high performance, scalable, and secure.
  • An open source system, developers can adapt and enhance it to accommodate future needs.
  • The PostgreSQL development model strongly emphasizes data integrity and accuracy.

Our Expertise

OmniTI has been deeply involved in supporting mission-critical services built upon the PostgreSQL database platform for almost 10 years. Alonside PostgreSQL, we also support MySQL, Oracle, and various NoSQL databases as well. This breadth of knowledge brings with it excellent experience in the ongoing management of database systems and maintains a uniquely healthy mentality in our support of large-scale business critical data operations.

  • Internationally recognized leaders in PostgreSQL technology
  • Regarded by the PostgreSQL community as having unparalleled experience managing the largest Postgres instances
  • Presentations around the globe at conferences including PGCon, Postgres Open, OSCON, Highload++, and Velocity, and various PGDays and Postgres User Groups
  • Authored the widely popular book Beginning PHP 5 and PostgreSQL
  • Developed commercial products using PostgreSQL as a core technology, including MessageSystems’s Message Central.
  • The creators of numerous open source projects around PostgreSQL such as pg_partman, pg_extractor, pg_jobmon, and mimeo.
  • Help to maintain phpPgAdmin
  • Lead the initiative to bring Sun’s ZFS and DTrace technologies into PostgreSQL

Our Support

Like all systems, the more you rely on them, the more important it is that they work. While PostgreSQL is exceptionally reliable, having an expert around when things don’t go as planned is essential. If PostgreSQL is truly critical to your business, the quality of your support is equally critical.

  • System sizing and initial configuration
  • Database architecture
  • Performance and scalability
  • 24x7 monitoring and management
  • Backups/Disaster recovery
  • Replication
  • Upgrades
  • Porting from other database technologies (Oracle, MySQL, DB2, etc.)

Selected Projects

  • Planned and executed the Oracle to PostgreSQL datawarehouse migration that saved PlasmaNet $700,000
  • Provided soup-to-nuts database direction for Message System’s Message Central product
  • Maintainers of OmniPITR, an advanced WAL file management tool.
  • Long term management of Postgres databases for several Alexa Top 1000 websites

Selected Articles

Our Book

Beginning PHP and PostgreSQL 8 by Robert Treat et al.

Let’s Talk

Contact Robert Treat to learn what we can do for you.

← More about our work and clients.

Get in Touch

All Services