Met Office
The UK-based Met Office is a global leader in weather and climate science. A trusted advisor to both national and international clients, the organisation enjoys a worldwide reputation at the forefront of meteorology and associated services.
The Met Office is a significant consumer of IT, utilising some of the most powerful computing technology available. The diversity of both hardware and software in use is impressive.With a legacy of earlier years of development under the remit of a trading fund, the organisation is on a mission to deliver a quality service for all its stakeholders whilst pursuing a drive for efficiency and value for money.
As a centre of excellence, the Met Office has an autonomous remit to control its IT infrastructure, including making decisions about database technology. In 2012, under the leadership of James Tomkins, Data Services Portfolio Technical Lead, the Met Office began evaluating database management systems in use, with the goal of reducing costs and introducing flexibility in terms of platform development and special requirements.
PostgreSQL was identified as a potential alternative to Oracle DB, and so began an evaluation process for specific projects, with the search for a suitable support partner, who could provide guidance, training and support. A commercial partner who could provide the same level of support expected from a proprietary database vendor.
2ndQuadrant was assigned to initially provide advice and help the team make a balanced assessment of PostgreSQL. Following some initial meetings, 2ndQuadrant were then invited back to provide a series of onsite training courses, specifically tailored to the needs of the organisation. With several teams participating in the training, this was an opportunity for the Met Office to really challenge 2ndQuadrant on our knowledge of PostgreSQL, and the PostGIS extension. Under the leadership of 2ndQuadrant’s resident PostGIS expert, the course participants were suitably impressed with the training we provided.
James Tomkins, Data Services Portfolio Technical Lead, Met Office
After rigorous testing, the evaluation process was completed in April 2014, with PostgreSQL being declared an approved product and recommended for all general purpose databases. The decision to select PostgreSQL was in the end straightforward. The maturity of back-up and recovery, high availability, replication and geospatial were all proven. It allowed them to have a database standard that’s available to both their scientists and collaborative community without the dependence on licence fees.
The Met Office’s commitment to PostgreSQL is now clear, with a programme to continue to evaluate and database management systems, where appropriate, to PostgreSQL. PostgreSQL and Oracle DB are now both designated general use database technologies. However, the Met Office has an ICT strategy that, subject to value for money and compliance, favours open source software over proprietary software, so use of PostgreSQL is set to expand.
James Tomkins, Data Services Portfolio Technical Lead, Met Office
James Tomkins, Data Services Portfolio Technical Lead, Met Office
2ndQuadrant Services Provided
- Training
- Consultancy
About 2ndQuadrant
2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases. This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services.
