{"id":1016,"date":"2026-10-23T09:41:49","date_gmt":"2026-10-23T09:41:49","guid":{"rendered":"https:\/\/ssi-bg.com\/?page_id=1016"},"modified":"2026-10-23T10:17:05","modified_gmt":"2026-10-23T10:17:05","slug":"postgresql","status":"publish","type":"page","link":"https:\/\/ssi-bg.com\/en\/postgresql\/","title":{"rendered":"PostgreSQL"},"content":{"rendered":"<div data-elementor-type=\"wp-page\" data-elementor-id=\"1016\" class=\"elementor elementor-1016\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4699502 e-flex e-con-boxed e-con e-parent\" data-id=\"4699502\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-11ed3a1 elementor-widget elementor-widget-html\" data-id=\"11ed3a1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<style>\r\n.ssi-pg{--pg-green:#19573B;--pg-accent:#3ED692;--pg-text:#1F1F1F;--pg-muted:#54595F;--pg-card:#ffffff;\r\n  font-family:\"Roboto\",Sans-serif;color:var(--pg-text);line-height:1.65;font-size:16px;max-width:1140px;margin:0 auto}\r\n.ssi-pg *{box-sizing:border-box}\r\n.ssi-pg h1,.ssi-pg h2,.ssi-pg h3{font-family:\"Roboto\",Sans-serif;font-weight:600;color:var(--pg-green);line-height:1.25;margin:0 0 14px}\r\n.ssi-pg h1{font-size:34px}\r\n.ssi-pg h2{font-size:28px}\r\n.ssi-pg h3{font-size:21px}\r\n.ssi-pg p{margin:0 0 14px}\r\n.ssi-pg ul{margin:0 0 14px;padding-left:22px}\r\n.ssi-pg li{margin-bottom:8px}\r\n.ssi-pg strong{font-weight:600}\r\n\r\n\/* \u0433\u043e\u0440\u043d\u0430 \u0447\u0430\u0441\u0442: \u043b\u043e\u0433\u043e + \u0432\u044a\u0432\u0435\u0434\u0435\u043d\u0438\u0435 *\/\r\n.ssi-pg .pg-hero{display:flex;flex-wrap:wrap;align-items:center;gap:30px;padding:10px 0 20px}\r\n.ssi-pg .pg-logo{flex:0 0 220px;text-align:center}\r\n.ssi-pg .pg-logo img{max-width:200px;height:auto;display:inline-block}\r\n.ssi-pg .pg-intro{flex:1 1 400px}\r\n.ssi-pg .pg-lead{font-size:18px}\r\n\r\n\/* \u0440\u0430\u0437\u0434\u0435\u043b\u0438\u0442\u0435\u043b\u0438 \u043a\u0430\u0442\u043e \u043d\u0430 \u043e\u0441\u0442\u0430\u043d\u0430\u043b\u0438\u0442\u0435 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0438 *\/\r\n.ssi-pg .pg-divider{border:0;border-top:1px solid #000;margin:15px 0}\r\n.ssi-pg .pg-divider.short{width:77%;margin:15px auto}\r\n\r\n\/* \u0434\u0432\u0435 \u043a\u043e\u043b\u043e\u043d\u0438 *\/\r\n.ssi-pg .pg-cols{display:flex;flex-wrap:wrap;gap:0 40px}\r\n.ssi-pg .pg-col{flex:1 1 420px;min-width:0}\r\n\r\n\/* \u043a\u0430\u0440\u0442\u0438 \u0437\u0430 \u0443\u0441\u043b\u0443\u0433\u0438\u0442\u0435 *\/\r\n.ssi-pg .pg-card{background:var(--pg-card);border-left:4px solid var(--pg-green);border-radius:4px;padding:22px 24px;margin-bottom:24px;box-shadow:0 2px 10px rgba(0,0,0,.05)}\r\n.ssi-pg .pg-card ul{margin-bottom:0}\r\n\r\n\/* \"\u0417\u0430\u0449\u043e SSI\" *\/\r\n.ssi-pg .pg-center{text-align:center}\r\n.ssi-pg .pg-why{list-style:none;padding:0;display:grid;grid-template-columns:repeat(auto-fit,minmax(240px,1fr));gap:20px;margin-top:20px}\r\n.ssi-pg .pg-why li{background:var(--pg-card);border-radius:4px;padding:20px;margin:0;border-top:4px solid var(--pg-accent);box-shadow:0 2px 10px rgba(0,0,0,.05)}\r\n.ssi-pg .pg-why strong{display:block;color:var(--pg-green);font-size:17px;margin-bottom:6px}\r\n\r\n\/* \u043f\u0440\u0438\u0437\u0438\u0432 \u0437\u0430 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435 *\/\r\n.ssi-pg .pg-cta{background:var(--pg-green);color:#fff;text-align:center;border-radius:4px;padding:36px 24px;margin:36px 0 10px}\r\n.ssi-pg .pg-cta h2{color:#fff}\r\n.ssi-pg .pg-cta p{color:#e8f3ee}\r\n.ssi-pg .pg-btn{display:inline-block;background:var(--pg-accent);color:#0f2e20 !important;font-weight:600;text-decoration:none !important;padding:12px 30px;border-radius:4px;margin-top:6px;transition:background .2s}\r\n.ssi-pg .pg-btn:hover{background:#fff}\r\n\r\n\/* \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u0438 \u043c\u0430\u0440\u043a\u0435\u0440\u0438 \u0437\u0430 \u043f\u043e\u043f\u044a\u043b\u0432\u0430\u043d\u0435 \u2013 \u0438\u0437\u0442\u0440\u0438\u0439\u0442\u0435 \u0433\u0438, \u043a\u043e\u0433\u0430\u0442\u043e \u0432\u044a\u0432\u0435\u0434\u0435\u0442\u0435 \u0440\u0435\u0430\u043b\u043d\u0438\u0442\u0435 \u0434\u0430\u043d\u043d\u0438 *\/\r\n.ssi-pg .todo{background:#fff3a3;padding:0 4px;border-radius:3px}\r\n\r\n@media(max-width:767px){\r\n  .ssi-pg h1{font-size:27px}\r\n  .ssi-pg h2{font-size:23px}\r\n  .ssi-pg .pg-logo{flex-basis:100%}\r\n  .ssi-pg .pg-divider.short{width:100%}\r\n}\r\n<\/style>\r\n\r\n<div class=\"ssi-pg\">\r\n\r\n  <!-- ===== \u0412\u044a\u0432\u0435\u0434\u0435\u043d\u0438\u0435 ===== -->\r\n  <div class=\"pg-hero\">\r\n    <div class=\"pg-logo\">\r\n      <!-- \u041a\u0430\u0447\u0435\u0442\u0435 \u043b\u043e\u0433\u043e\u0442\u043e \u043d\u0430 PostgreSQL \u0432 Media Library \u0438 \u0441\u043c\u0435\u043d\u0435\u0442\u0435 src \u0441 \u043d\u0435\u0433\u043e\u0432\u0438\u044f \u0430\u0434\u0440\u0435\u0441 -->\r\n      <img decoding=\"async\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/2\/29\/Postgresql_elephant.svg\" alt=\"PostgreSQL\" width=\"200\" height=\"206\">\r\n    <\/div>\r\n    <div class=\"pg-intro\">\r\n      <h1>PostgreSQL Support and Administration<\/h1>\r\n      <p class=\"pg-lead\">SSI provides professional PostgreSQL support, administration, optimization and migration services. PostgreSQL is the leading open-source relational database management system, trusted by organizations around the world.<\/p>\r\n      <a class=\"pg-btn\" href=\"https:\/\/ssi-bg.com\/en\/contacts\/\">Request a Consultation<\/a>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <hr class=\"pg-divider\">\r\n\r\n  <!-- ===== \u0417\u0430 SSI ===== -->\r\n  <h2>SSI \u2013 Your PostgreSQL Partner<\/h2>\r\n  <p>We help public and private sector organizations build, maintain and evolve reliable PostgreSQL environments. Our team of certified specialists has many years of experience with business-critical systems. We handle both urgent incidents and long-term planning for the capacity, security and growth of your databases.<\/p>\r\n  <p>We serve clients throughout Bulgaria and work in both Bulgarian and English.<\/p>\r\n\r\n  <hr class=\"pg-divider\">\r\n\r\n  <!-- ===== \u0423\u0441\u043b\u0443\u0433\u0438 ===== -->\r\n  <h2>Our Services<\/h2>\r\n\r\n  <div class=\"pg-cols\">\r\n    <div class=\"pg-col\">\r\n      <div class=\"pg-card\">\r\n        <h3>PostgreSQL Support and Monitoring<\/h3>\r\n        <ul>\r\n          <li><strong>Incident Response<\/strong> \u2013 rapid diagnosis and recovery from outages, lockups or performance degradation.<\/li>\r\n          <li><strong>Proactive Monitoring<\/strong> \u2013 we track load, replication, disk space and locks to catch problems before they affect your users.<\/li>\r\n          <li><strong>Performance Optimization<\/strong> analysis of slow queries, indexes and execution plans (EXPLAIN), plus server parameter and autovacuum tuning.<\/li>\r\n        <\/ul>\r\n      <\/div>\r\n\r\n      <div class=\"pg-card\">\r\n        <h3>Managed PostgreSQL Services<\/h3>\r\n        <ul>\r\n          <li><strong>Full Administration<\/strong> we take over day-to-day database management so your team can focus on building your products.<\/li>\r\n          <li><strong>Backup and Recovery<\/strong> \u2013 implementation and regular testing of backup strategies, including point-in-time recovery (PITR) with pgBackRest or Barman.<\/li>\r\n          <li><strong>Periodic Audits<\/strong> \u2013 regular system health reviews with actionable recommendations.<\/li>\r\n          <li><strong>Root Cause Analysis<\/strong> \u2013 after every incident, we identify the cause and take steps to prevent it from happening again.<\/li>\r\n          <li><strong>Extension Support<\/strong> \u2013 PostGIS, pgvector, pg_stat_statements, TimescaleDB and more.<\/li>\r\n        <\/ul>\r\n      <\/div>\r\n    <\/div>\r\n\r\n    <div class=\"pg-col\">\r\n      <div class=\"pg-card\">\r\n        <h3>Consulting, Architecture and Migrations<\/h3>\r\n        <ul>\r\n          <li><strong>New System Design<\/strong> \u2013 data model, architecture and infrastructure designed for your expected growth.<\/li>\r\n          <li><strong>High Availability<\/strong> \u2013 streaming replication, automatic failover (Patroni, repmgr) and connection pooling (PgBouncer).<\/li>\r\n          <li><strong>Version Upgrades<\/strong> \u2013 planned upgrades to new PostgreSQL versions with minimal downtime.<\/li>\r\n          <li><strong>Migration from Other Systems<\/strong> \u2013 moving data and logic from Oracle, Microsoft SQL Server or MySQL to PostgreSQL.<\/li>\r\n          <li><strong>Containers and Cloud<\/strong> \u2013 PostgreSQL on Kubernetes, Docker and cloud platforms.<\/li>\r\n        <\/ul>\r\n      <\/div>\r\n\r\n      <div class=\"pg-card\">\r\n        <h3>Security and Compliance<\/h3>\r\n        <ul>\r\n          <li><strong>Access Control<\/strong> \u2013 role and permission management, connection encryption (TLS) and access auditing.<\/li>\r\n          <li><strong>Regulatory Compliance<\/strong> \u2013 bringing your databases in line with GDPR and NIS2 requirements.<\/li>\r\n        <\/ul>\r\n      <\/div>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <!-- ===== \u0417\u0430\u0449\u043e SSI ===== -->\r\n  <hr class=\"pg-divider short\">\r\n  <h2 class=\"pg-center\">Why Choose SSI?<\/h2>\r\n\r\n  <ul class=\"pg-why\">\r\n    <li><strong>Proven Experience<\/strong>We work with PostgreSQL in real production environments.<\/li>\r\n    <li><strong>Fast Response<\/strong>Fast response to critical incidents, in line with the agreed SLA.<\/li>\r\n    <li><strong>Flexible Engagement<\/strong>Hourly consulting, a monthly support subscription or a long-term contract.<\/li>\r\n    <li><strong>No Vendor Lock-in<\/strong>We use standard open-source tools, so your environment stays independent of any single vendor.<\/li>\r\n  <\/ul>\r\n\r\n  <!-- ===== \u041f\u0440\u0438\u0437\u0438\u0432 \u0437\u0430 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435 ===== -->\r\n  <div class=\"pg-cta\">\r\n    <h2>Need Help with PostgreSQL?<\/h2>\r\n    <p>Contact us to discuss how we can make your databases faster, more secure and more reliable.<\/p>\r\n    <a class=\"pg-btn\" href=\"https:\/\/ssi-bg.com\/en\/contacts\/\">Contact us<\/a>\r\n  <\/div>\r\n\r\n<\/div>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>PostgreSQL \u043f\u043e\u0434\u0434\u0440\u044a\u0436\u043a\u0430 \u0438 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0446\u0438\u044f SSI \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430 \u043f\u0440\u043e\u0444\u0435\u0441\u0438\u043e\u043d\u0430\u043b\u043d\u0430 \u043f\u043e\u0434\u0434\u0440\u044a\u0436\u043a\u0430, \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0446\u0438\u044f, \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f \u0438 \u043c\u0438\u0433\u0440\u0430\u0446\u0438\u044f \u043d\u0430 PostgreSQL \u2013 \u0432\u043e\u0434\u0435\u0449\u0430\u0442\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0437\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043d\u0430 \u0440\u0435\u043b\u0430\u0446\u0438\u043e\u043d\u043d\u0438 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u043d\u0438 \u0441 \u043e\u0442\u0432\u043e\u0440\u0435\u043d \u043a\u043e\u0434, \u043d\u0430 \u043a\u043e\u044f\u0442\u043e \u0440\u0430\u0437\u0447\u0438\u0442\u0430\u0442 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u043f\u043e \u0446\u0435\u043b\u0438\u044f \u0441\u0432\u044f\u0442. \u0417\u0430\u044f\u0432\u0435\u0442\u0435 \u043a\u043e\u043d\u0441\u0443\u043b\u0442\u0430\u0446\u0438\u044f SSI \u2013 \u0432\u0430\u0448\u0438\u044f\u0442 \u043f\u0430\u0440\u0442\u043d\u044c\u043e\u0440 \u0437\u0430 PostgreSQL \u041f\u043e\u043c\u0430\u0433\u0430\u043c\u0435 \u043d\u0430 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u043e\u0442 \u043f\u0443\u0431\u043b\u0438\u0447\u043d\u0438\u044f \u0438 \u0447\u0430\u0441\u0442\u043d\u0438\u044f \u0441\u0435\u043a\u0442\u043e\u0440 \u0434\u0430 \u0438\u0437\u0433\u0440\u0430\u0436\u0434\u0430\u0442, \u043f\u043e\u0434\u0434\u044a\u0440\u0436\u0430\u0442 \u0438 \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0442 \u043d\u0430\u0434\u0435\u0436\u0434\u043d\u0438 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1016","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ssi-bg.com\/en\/wp-json\/wp\/v2\/pages\/1016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ssi-bg.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ssi-bg.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ssi-bg.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ssi-bg.com\/en\/wp-json\/wp\/v2\/comments?post=1016"}],"version-history":[{"count":5,"href":"https:\/\/ssi-bg.com\/en\/wp-json\/wp\/v2\/pages\/1016\/revisions"}],"predecessor-version":[{"id":1023,"href":"https:\/\/ssi-bg.com\/en\/wp-json\/wp\/v2\/pages\/1016\/revisions\/1023"}],"wp:attachment":[{"href":"https:\/\/ssi-bg.com\/en\/wp-json\/wp\/v2\/media?parent=1016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}