PostgreSQL 10: Logical – Table-Based Replication
With PostgreSQL 10, along with the existing Streaming Replication (Physical Replication) feature, the Logical Replication feature was introduced. Thanks to this feature, we can now use some flexible replication capabilities that we could not do before. To define Logical Replication basically and first its differences from physical Streaming Replication...
Our ISO 9001:2015 Certificate Has Been Updated
Following the efforts to align our company's existing Quality Management System with the new version, it was observed during the surveillance and transition audit conducted on 17.05.2018 that the required adjustments had been implemented, making it suitable for the transition to the new version, which was approved by the quality certification company. Our certificate ISO 9001:2015...
Advantages of Agentless Remote Session Auditing and Recording Systems Over Agent-Based Technologies
The purpose of this article is to highlight the key differences between session recording systems that use agents and Shell Control Box, which offers an agentless technology.
IBM – EnterpriseDB Event
On December 14, 2017, at the 'EnterpriseDB / PostgreSQL on IBM Power Systems" event held in Istanbul in collaboration with IBM and Profelis, EnterpriseDB and IBM partnership was highlighted, covering EnterpriseDB Postgres Advanced Server and PostgreSQL database supports on Power systems.
Shell Control Box (5 LTS) Maintenance Release 5.0.3 Released
Shell Control Box (5 LTS) Maintenance Release 5.0.3 Released The most important issue resolved in this release: ID: PAM-2146 Summary: ‘Error parsing incoming data’ in RDP logs Description: In some cases, PSM did not correctly parse the error messages received from the...
Achieving PCI-DSS Compliance with PostgreSQL
PCI-DSS version 4 is about to be released. PCI-DSS is an international security regulation that determines security standards when shopping with credit cards and makes certificates mandatory according to merchants' levels. PCI-DSS standards (regulations), among its members, include major companies such as Mastercard, Visa, American Express, Discover Services, Veracode...
PostgreSQL 101: Indexes and Index Types
The index types supported by PostgreSQL are B-tree, hash, GiST, GIN, and BRIN. The PostgreSQL database supports single-column, multicolumn, partial index, unique index, expression index, implicit index, and concurrent indexes.
PostgreSQL 101: Index Maintenance
Regardless of the brand, indexes in every database have the potential to cause problems in systems subject to high write/delete operations. Just as tables can bloat, indexes can bloat as well. Non-primary key indexes can bloat even during normal insert operations. On the other hand, autovacuum handles this bloated...
PostgreSQL – JSON Data Type Operations
It was a big deal when the JSON data type and supporting functions began to be supported with PostgreSQL version 9.2. Today, while other databases are starting to support this data type one by one following PostgreSQL, there is well-established JSON support in PostgreSQL. JSON, web applications, JavaScript...
PostgreSQL Performance: max_connections
max_connections holds an important place in PostgreSQL performance settings. During the opening, closing, and reopening of each connection, a surge and resource consumption occurs. Therefore, this value can be expressed in the hundreds on powerful hardware, but if your need is greater, for example, if you need thousands of connections...
The cookies used are necessary for the website to function and cannot be switched off. These cookies are only set in response to actions made by you. If you block these cookies through your browser, some parts of the site may not work.
For more information, review our privacy policy.
Close