PostgreSQL Integration Part 2: Data Integration and Migration
We are continuing our PostgreSQL integration blog series, which started with the Application Integration article. Now, we will continue exploring PostgreSQL integration to enable organizations to work more and faster. This blog post focuses on another important topic in the field: Data Integration and Migration. Data Integration...
PostgreSQL Integration Part 1: Application Integration
Over the past decade, open-source databases have won the hearts and minds of developers and database operators worldwide. When you double-click on open-source trends, you can clearly see that PostgreSQL is the most preferred database. The reasons for this are clear: innovation, reliability, cost, and a broad platform...
Best Security Practices for PostgreSQL
1. Abstract This white paper presents a framework and a set of recommendations for securing and protecting the PostgreSQL database. It discusses a layered security model that addresses physical security, network security, server access control, database access management, and data security...
Leaving Oracle
In this webinar organized jointly by Profelis Bilişim ve Danışmanlık, the EnterpriseDB Türkiye Distributor and the only authorized training center in the region, and EnterpriseDB, we will discuss the paths and advantages for teams migrating their Oracle databases to PostgreSQL. In 2020, through EnterpriseDB's Migration Portal, 2.2...
Postgres on Docker — volumes
We started our article series with the installation of PostgreSQL and PgAdmin on Docker. Next, we will examine volume management, which is another important topic in Docker. To do this, we will start by running the PostgreSQL 11 image. Do not start with another version because later in the article we will update our data to PostgreSQL 11.7 without breaking it....
Global Leader ABN AMRO CLEARING Migrates Its System to EDB Postgres
ABN AMBRO Clearing, a recognized global leader in derivatives and equity swaps, is one of the few companies capable of providing global market access and clearing services across more than 85 financial exchanges. The company operates in 12 different locations worldwide and processes 16...
EnterpriseDB Index Advisor
We explained the EnterpriseDB Index Advisor tool and its usage. By watching this video, you can gain the following benefits: – Basic steps to install the Index Advisor tool – Identifying index needs with the Index Advisor tool – Using the Index advisor tool via the PEM management interface, SQL Profiler...
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...
