Enterprise PostgreSQL Services | Equnix Business Solution

Get the world’s most advanced database with PostgreSQL

The Enterprise Class Database Management System

PostgreSQL is an excellent database management system for use in enterprise class businesses. It is capable of handling high workload levels constantly and robustly. With more than 30 years of active development, PostgreSQL proves an equal, and even better database system for enterprises. PostgreSQL provides reliability, data integrity and correctness through a strong architecture, with the add-in advantage of no licensing fees or vendor lock-in.

PostgreSQL is the DBMS of the Year 2017

PostgreSQL is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 341 monitored systems.
We thus declare PostgreSQL as the DBMS of the Year 2017.

While in our last year's popularity ranking PostgreSQL already ran in on place 3, 2017 was an even better year for PostgreSQL. With a total gain of 55.81 scoring points (+17%) and improving its score in each of the single monthly rankings of 2017, it outperformed all other systems in 2017.

Hassle Free PostgreSQL Solution with Equnix
Equnix' comprehensive services offering for PostgreSQL

Managed Services

Equnix delivers PostgreSQL Managed Services for clients needing total support.

Services Include:
  • Remote DBA
  • Server can be on client premise
  • Security Improvement
  • Scalability Monitoring
  • Frequent Server-side Tuning
  • Query Tuning by examining slow query log
  • Time to Resolution Maximum is 4 hours.
  • Consultation included
  • SLA up to 99,99 % (maximum tolerable downtime: 52 minutes/year)

Maintenance Services
Professional services that help maintain your database.

Equnix provides professional maintenance services to help maintain your PostgreSQL database system with local support, including:

Preventive Maintenance (PM) Corrective Maintenance (CM)
  • On-Site Standby Support by Appointment (migration, maintenance, etc.)
  • Scheduled Maintenance (every 3 months)
  • Consultative for Mission Critical Condition, by appointment
  • On Web/Ticket
  • On Email Support
  • On-Phone Support
  • On-Remote Support
  • On-Site Support
  • Time to Respond max 1 hour.
  • Time to On-Site max 4 hours.
  • Time to Resolve (Fix/Workaround) max 4 hours.

PostgreSQL Advanced Training

PostgreSQL Training for those who’s eager to learn more about the World’s Most Advanced ORDBMS. Our Training improves your knowledge on PostgreSQL, both on fundamentals and Advanced levels. It’s taught by our experienced experts and best practitioners in PostgreSQL.

We provide 2 level of training:

  • In house Basic PostgreSQL: Covering basic knowledge on SQL and general RDBMS.
  • In house Advanced PostgreSQL: Covering detailed knowledge about PostgreSQL foundations and Performance Experience for Developer or General Database Administrator.

Our training is backed with Professional Certification.

Success Story of PostgreSQL

  • PT. Bank Danamon Indonesia Tbk. (Bank Danamon)
    Maintenance Services PostgreSQL

    Bank Danamon is one the largest banks in Indonesia, established since 1956 and now has 1.901 branches. Bank Danamon’s valuation reaches Rp 50 Trillion, and has been listed as an emitent in Bursa Efek Jakarta.

    Bank Danamon chooses PostgreSQL database system to handle their Corporate Internet Banking application. With PostgreSQL delivered by Equnix, Bank Danamon obtains support services, cost-effectiveness and trusted data security.

    Bank Danamon is satisfied with Equnix’ services, which saves investment while answering the dynamics in banking demands. With only OPEX investment, Bank Danamon improves its competitive agility.

  • Bank BJB (Bank Jabar Banten)
    Maintenance Services PostgreSQL

    Bank BJB is a provincial government-owned (BUMD) belonging to Pemerintah Provinsi Jawa Barat dan Banten, established since 1961. Since 1992 Bank BJB status increased to a General bank, which extends its breadth of products and services.

    Bank BJB chooses PostgreSQL to handle applications that support Electronic Banking. Equnix delivers PostgreSQL Maintenance Service for BJB, including installation, configuration, and preventive and corrective maintenance.

    Equnix serves Bank BJB since 2012. Equnix’s tuning improves BJB’s database server’s performance from 2.500 TPS to 5.000 TPS. Now PostgreSQL handles multiple Bank BJB applications including Transaction Gateaway, Web Teller, Pajak Daerah, Switching, and Sistem Monitoring.

  • PT. Transretail Indonesia (Carrefour Indonesia)
    Migration, Clustering PostgreSQL nationwide, and High Performance OLTP

    Carrefour Indonesia is one of Indonesia’s largest chain of modern retail stores. Since 2013 Carrefour Indonesia has been a busines entity wholly owned by an Indonesian corporation., CT Corp.

    Carrefour Indonesia’s chain of retail stores needs a sophisticated transactional database system. With PostgreSQL delivered by Equnix, Carrefour Indonesia saves yearly cost for 100+ stores, 3000+ POS machines, 170.000+ item variants, with millions of daily transaction.

    PostgreSQL implementation in Carrefour Indonesia includes servers in stores to the Head Office to store transaction data in realtime online and standalone, through Multimaster Replication model. With PostgreSQL, Carrefour Indonesia achieved optimal service with total support from dukuingan total dari Equnix while maintaining low and effective investment.

  • PT EDI Indonesia (EDII)
    Managed Services, Migration Services and In-House PostgreSQL Training

    PT EDI Indonesia is a subsidiary of PT Pelabuhan Indonesia II (Persero), established since 1995 as a pioneer in Electronic Data Interchange services. In Indonesia. EDII has more than 18 years of experience in giving various e-business solutions.

    EDII migrated from beralih the market leader database system to PostgreSQL, to improve performance and data integrity of their database system. EDII entrusts Equnix for PostgreSQL Managed Services, which includes database migration to PostgreSQL, and In-House Training.

    Initial benchmarking results from Equnix over EDII’s hardware spesifications achieved 14.000 TPS. This is a number which suffices for a database system daily operation.

    In-House PostgreSQL Training

    MIMOS is a strategic agency under Kementerian Sains, Teknologi dan Inovasi Malaysia, which is focused in research and development.

    Equnix provided training for PostgreSQL database management system to MIMOS DBAs and developers. Materials taught include conceptual and technical overviews, PostgreSQL features exploration, and technical capabilities on PostgreSQL features such as backup, restore and replication.

    Previously MIMOS had received PostgreSQL training from another provider, but with less effective results. On the contrary, MIMOS is satisfied with Equnix’ training, in which MIMOS had more than once assinged Equnix for PostgreSQL training.

Advanced database features for PostgreSQL Services from Equnix
Supporting businesses with Enterprise class features

24/7 support

PostgreSQL is delivered with local professional support from Equnix, up to 24 hours a day, 7 days a week. With our qualified professional talents and experiences in managing and maintaining PostgreSQL database system in enterprise business clients, we ensure your system is always up and running.

High Availability

PostgreSQL is capable of providing minimum downtime guarantee. Tuning and configuration from Equnix with High Availability or Cyclic High Availability concepts enables PostgreSQL to provide up to 99.9% up-time level for your database, which translates into less than one hour of downtime per year.

Failover in 10secs

With High Availability in place, PostgreSQL can guarantee maximum Failover time of only 10 seconds or less. This increases your database server’s overall service operation availability and make sure there’s no hassle in handling unplanned downtimes.

High Performance OLTP

PostgreSQL supports Online Transactional Processing demands of stable and robust handling of constantly high read-write workloads, while maintaining data integrity and security. There has never been a report of PostgreSQL crash from Equnix clients. Banking and Telco operators benefit greatly from this feature.

Multi-Master Replication

PostgreSQL supports various modes of data replication between server nodes, including Multi-Master Replication, that enables multiple node to have the Master status at the same time. This supports Distributed Workload across geographies, Load Balancing, Clustering, and data management design ease, to cater dynamic data collection.

Load Balancing / Clustering

PostgreSQL supports balancing workloads between database servers through implementation of Load Balancing and Clustering concepts. This mainly avoids overload in any of the server nodes, while at the same time optimizes resource utilization, maximize throughput, minimizes response time, and reduces hardware cost through scaling out, which is far more affordable than scaling up.

Point-in-Time Recovery (PITR)

PostgreSQL is capable of doing multiple modes of backup and recovery, including Point-in-Time Recovery. This provides the database system with a “Time Machine”, which enables it to recover from any crash to a certain point in time through use of write-ahead logs. With the possibilities of human error, this can save the world for you.

DRC Ready

With the previous features, plus Native Asynchronous Replication, Full/Incremental Backup and recovery modes, and ease of data resynchronization mechanisms, PostgreSQL is able to support the full feature set of Disaster Recovery Center (DRC) readiness, enabling your database to recover from any disaster, without adding more cost/tools.

Migration from any Database

PostgreSQL’s architecture is so flexible that it supports migration from any existing database system, both relational or non-relational models. One of great features is Foreign Data Wrappers which enable any foreign database to be linked to PostgreSQL. Database migration is never been this easier.

NoSQL / Big Data Support

Although it is Relational by design, PostgreSQL also supports NoSQL for handling Big Data and using JSONB (JSON Binary) in storing JSON documents type data. This extends PostgreSQL’s usage reach out to not only structured data but also to the rapidly developing unstructured data. This capability ensure removes doubt in choosing between SQL or NoSQL as we can have both at the same time.

Flash Reporting

PostgreSQL has sophisticated features to fetch data in every possible complex queries. With enhanced power of parallel processing, query execution time can be sliced down while maximizing the available resources. Moreover, the parallel processing can optimize index usage and result aggregation to construct "well-done" data. This OLAP-friendly feature fastened reporting generation, especially when the database is profiled as data warehouse.

Native Scalability

Needs of flexible storage for huge data growth is covered in PostgreSQL's Native Partitioning implementation. Data can be chunked into several partitions based on the constraints, while querying the main table may gives aggregated results. On-demand partition may be added as easily as running a single query, without altering whole rules which have been configured earlier. By combining with tablespaces, PostgreSQL gives easiness and agility to setup persistence infrastructure.

Easy Centralized Consolidation

In the latest advancement, PostgreSQL is enchanced with Logical Replication, as another option for Native Streaming Replication. Logical Replication can be configured per database or per table. With table replication, we can consolidate any transaction from all around the World without hassle into single location. Table replication is the next big thing for distributed system, distributed applications, and it will disrupt on how we developed distribution applications.

Omni Data Interoperability

PostgreSQL gives choices to select from where you want to fetch data, natively and externally. External data such as XML, CSV, Plain Text File, or even other RDBMS can be accessed within PostgreSQL instance. PostgreSQL enables result combination of these external reference and native data tables. On latest version of PostgreSQL, you can intepret your XML documents and aggregate with other tables to get comprehensive results for your reporting.

PostgreSQL’s High Performance in Action
Proofs in benchmark results

PostgreSQL has been tested and proven in many tests. Equnix’ internal benchmarks confirms thier results.

PostgreSQL vs Oracle Performance Comparison on Intel E5-2643 machine. PostgreSQL exceeds Oracle by 7 times!
PostgreSQL performance comparison on IBM Power8 Machine. Achieving 27K+ QPS on IBM Power8.

*The benchmarks were done in accordance to the world standard TPC-B and TPC-C transactional database standards. The standards were created and maintained by the Transaction Performance Processing Council, a non-profit corporation focused on developing data centric benchmark standards. (www.tpc.org)

Equnix has helped Businesses of all size, in every industry
We Deliver Enterprise Class Database Solutions

Equnix Business Solutions is a trusted and customer oriented IT Solutions Provider. We focus in providing the best Enterprise Solution for businesses. Our solutions are based on highly proven Open Source technologies and world class quality Software Development.

We are IBM Business Partner as Technology enabler in delivering IBM Power Solution. Through our Expertise and Services, Equnix delivers High Performance PostgreSQL on top of IBM PowerLinux and LinuxOne/z Machine.

We have been SELECTed by Fujitsu Indonesia as their Expert Partner. (Fujitsu SELECT Expert Partner)
We are happy to become your high performance technology enabler in Infrastructure and Retail Solutions. Our Expertise and Professional Experience has proven through years in delivering Solutions to Enterprises and/or Corporations.

Silver partners pgDay Asia. pgDay Asia is the PostgreSQL conference series for all PostgreSQL enthusiasts in the Asia Pacific region. pgDay Asia 2017, will be held on the aegis of FOSSASIA 2017.
Friday, March 17 (D-1), TKP Conference Center 137, Cecil St Singapore 069537 (3rd Floor Fuji room).
Saturday, March 18 (D-2), Singapore Science Centre, 15 Science Centre Rd, Singapore 609081.

Silver sponsor PGConf.ASIA 2017. PGConf.ASIA is an international conference for PostgreSQL.
PGconf.ASIA 2017 will be held on December 4 to 6 in Akihabara convention hall (Tokyo) and Conference will be opened with Keynote Speaking by Julyanto Sutandang.

Need further information?

Don't hesitate to Call us at 0811-11-888-12
Or fill out the interactive form below

I would like to...