With our PostgreSQL\u00ae<\/sup> Competence Center, we support the entire PostgreSQL\u00ae<\/sup> life cycle in your organization. From the initial consultation onward, our PostgreSQL\u00ae<\/sup> Competence Center is available as a reliable and competent point of contact. <\/p>\n We support you with your migration projects, provide operational support on request, or fully assume operation of your entire PostgreSQL\u00ae<\/sup> environment.<\/p>\n Our PostgreSQL\u00ae<\/sup> team supports you with all questions related to PostgreSQL\u00ae<\/sup>. This naturally includes topics such as high availability, clustering and replication, tuning and optimization, customized monitoring environments, as well as development services and individual workshops and training sessions. <\/p>\n PostgreSQL\u00ae<\/sup> is an object-relational database management system (ORDBMS) that is freely available as open-source software and may be downloaded and used without licensing.<\/p>\n POSTGRES was originally developed as an academic project at the University of California at Berkeley Computer Science Department. Since then, many developers around the world have continued working on this code, and the project was renamed PostgreSQL\u00ae<\/sup> in 1996. <\/p>\n PostgreSQL\u00ae<\/sup> is rightly referred to as “the most advanced open-source database system” and supports the SQL92 and SQL99 standards. In addition, PostgreSQL\u00ae<\/sup> offers a range of its own extensions. <\/p>\n Our service and support provides you with professional and comprehensive assistance for PostgreSQL\u00ae<\/sup>.<\/p>\n Databases in particular hold very important or even strategic significance in enterprise environments. With our support, you secure the operation of your PostgreSQL\u00ae<\/sup> databases in business-critical operations just as you would when using proprietary, commercial software. <\/p>\n Our support model offers you many advantages that you will only find with us:<\/p>\n We offer you comprehensive consulting and cover all areas of using PostgreSQL\u00ae<\/sup> in enterprise environments with our services, from initial planning to productive deployment. We accompany you through the entire PostgreSQL\u00ae<\/sup> life cycle. <\/p>\n Our PostgreSQL\u00ae<\/sup> Competence Center is also available for services that go far beyond standard support.<\/p>\n Our team is familiar with PostgreSQL\u00ae<\/sup> down to the code level and will help you even when things get really deep.<\/p>\n In a database system, schema design plays a major role.<\/p>\n Constraints ensure data consistency. Performance depends critically on proper normalization. <\/p>\n We are happy to support you with schema design, regardless of whether the goal is data storage with maximum consistency and semantic accuracy in ideal normalization or performance maximization through star schemas in your data warehouse.<\/p><\/div><\/div><\/div>\n Performance problems with PostgreSQL\u00ae<\/sup> deployment? Wherever the bottleneck is, we quickly identify it and present solutions. <\/p>\n These can be of the most varied nature, such as tuning the schema or PostgreSQL\u00ae<\/sup> configuration, changing cost model parameters, rewriting inefficient stored procedures in C as a PostgreSQL\u00ae<\/sup> extension, or even with the clear statement that “more hardware” is the only solution.<\/p><\/div><\/div><\/div>\n Thanks to Postgres’ amortizing query analysis, critical queries can be quickly identified.<\/p>\n When looking at the query plan with EXPLAIN, you can also see the exact technical reason for a query’s undesirable performance behavior. While simple problems\u2014such as a missing index\u2014can be quickly identified and resolved here, problems occasionally run deeper. A plan can, for example, also be poor due to unfavorable parameterization of the cost model, or because the planner lacks suitable statistics for selecting a good query plan. <\/p>\n Here you can draw on our many years of experience puzzling with query plans, gladly together with appropriate knowledge transfer.<\/p><\/div><\/div><\/div>\n PostgreSQL\u00ae<\/sup> has long since ceased to be tied to a single node.<\/p>\n With various replication solutions, cluster systems can be built for different requirements.<\/p>\n Depending on whether the focus is high availability or load balancing, different replication solutions and configurations are used.<\/p><\/div><\/div><\/div>\n Did you know that Skype’s worldwide telephony infrastructure uses PostgreSQL\u00ae<\/sup>?<\/p>\n Of course, this is no longer possible with a single instance, but requires load balancing across thousands of nodes.<\/p>\n Whether 2 or 1,000 instances, we know the techniques for proper load balancing with PostgreSQL\u00ae<\/sup> and are happy to advise you.<\/p><\/div><\/div><\/div>\n The PostgreSQL\u00ae<\/sup> ecosystem has demonstrated stability for years. Nevertheless, problems occasionally occur, whether in the PostgreSQL\u00ae<\/sup> core, extensions, monitoring, or backup solutions. <\/p>\n The PostgreSQL\u00ae<\/sup> Competence Center helps you detect errors early through proactive patch management for your open-source products. Additionally, our team supports you with critical bugs, from detection through the bug fix itself to integration into upstream. <\/p>\n Furthermore, we also offer extended LTS support<\/a> for certain versions of the popular database. More information can be found here<\/a>. <\/p><\/div><\/div><\/div>\n One often hears in hindsight that an expensive incident could have been avoided by an expert review of the system.<\/p>\n If you have business-critical databases whose health status is unknown to you, we are happy to examine them with our many years of experience.<\/p><\/div><\/div><\/div>\n Although relational databases currently have a somewhat non-agile reputation, we are completely open to agile methods with PostgreSQL\u00ae<\/sup>.<\/p>\n In our experience, pair programming between application development and PostgreSQL\u00ae<\/sup> veterans can be very effective.<\/p>\n Of course, only if your SCRUM master sees it that way as well\u2026<\/p><\/div><\/div><\/div>\n <\/p><\/div>\n <\/p>\n With our operational support, we are always there for you. We handle load peaks, support you during vacation periods and in case of illness-related absences. <\/p>\n We are happy to assume the role of database administrator in critical staffing situations.<\/p>\n Are you considering migrating an existing application from another database management system such as Oracle\u00ae<\/sup>, DB2\u00ae<\/sup>, Informix\u00ae<\/sup>, or MS SQL Server to PostgreSQL\u00ae<\/sup>?<\/p>\n We have been offering our customers migration support to PostgreSQL\u00ae<\/sup> from the beginning. We support many proprietary and legacy database systems. Our team has extensive experience. Additionally, our team has developed the credativ-pg-migrator<\/em><\/a>, an open-source tool that can automate part of the migration. Furthermore, we work closely with our partner SplendidData, through which we have access to their commercial tool Cortex<\/em> and our partner’s wealth of experience to specifically migrate Oracle\u00ae<\/sup> databases to PostgreSQL. <\/p>\n We support you at every step, from feasibility assessment and effort estimation through selection of the right tools and schema migration to fast and smooth data transfer for a switchover with the lowest possible downtime. Naturally, we also support you with migration from an on-premise environment to a future cloud environment, but also in the reverse direction, from the cloud environment back to an internal on-premise environment or to your own private cloud. <\/p>\n We employ experienced PostgreSQL\u00ae<\/sup> developers who support you with further development and troubleshooting in the database server.<\/p>\n Through access to the source code, errors and performance bottlenecks can be well localized; our experience helps you make PostgreSQL\u00ae<\/sup> even more reliable.<\/p>\n For PostgreSQL\u00ae<\/sup>, we also develop custom extensions and additional modules\u2014naturally also under a free open-source license. We have therefore created a dedicated page for this topic: Migration to PostgreSQL<\/a> <\/p>\n Would you like to migrate your existing database to PostgreSQL\u00ae<\/sup> and operate it in a cloud environment?<\/p>\n credativ\u00ae supports the entire database life cycle for PostgreSQL\u00ae<\/sup> databases in typical cloud environments, such as Microsoft Azure or Amazon AWS. We offer comprehensive consulting and services in all areas related to PostgreSQL\u00ae<\/sup> in enterprise environments. From initial planning to productive deployment, our dedicated PostgreSQL\u00ae<\/sup> team is available to you. <\/p>\n The PostgreSQL\u00ae<\/sup> Competence Center at credativ GmbH develops and maintains the freely available open-source project Elephant Shed. Elephant Shed is a powerful software appliance that provides a complete PostgreSQL\u00ae<\/sup> database environment including all tools useful and necessary for operation. This appliance can be deployed at any time as a ready-to-use database server. Elephant Shed is available for deployment on dedicated hardware as well as in virtualized environments. There are no costs for subscriptions or licenses. Further information about Elephant Shed<\/a> is available here. <\/p>\n Naturally, training, courses, and workshops are also part of the services offered by our PostgreSQL\u00ae Competence Center.<\/p>\nWhat is PostgreSQL\u00ae?<\/h2>\n
PostgreSQL\u00ae Support<\/h2>\n
\n
Consulting<\/h2>\n
\n
Deep-Level Services<\/h2>\n
Operational Support and Operational Takeover<\/h2>\n
PostgreSQL\u00ae Migrations<\/h2>\n
PostgreSQL\u00ae in the Cloud<\/h2>\n
Elephant Shed – the Free PostgreSQL\u00ae Software Appliance from credativ<\/h2>\n
Training, Courses, and Workshops<\/h2>\n