PostgreSQL

If you notice that there is an error in the PostgreSQL time when you make time-dependent queries in PostgreSQL, you can change it by following …

  Master Server / Primary Server Set Up 1. Configuration Changes in file “postgresql.conf“ [crayon-67d4290d59f68652948946/]   2. Configuration Changes in file “pg_hba.conf” Make an entry …

  In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data …

  Oracle_client is required to connect to remote Oracle databases. For Oracle Foreign Data Wrapper, this installation needs to be done as follows. First of …

  Sometimes the standard installation is not sufficient for the extension package you want to install. The reason for this is that the extension has …

  When you run the make command when installing Oracle_fdw, you may encounter the error as follows. The reason for this error is that the …

  Uuid is the abbreviation for “universal unique identifier”. It consists of 36 characters, a set of numbers and letters, and its most important feature …

We may want to change the schema name because of some needs. For this we can use the following script. First, we list the schemes …

One of the useful data types of PostgreSQL is the inet data type. inet is used to define IPv4 and IPv6 addresses. The ip address …

  You can use the following queries to monitor the performance of the database or to find and kill queries that cause lock. The following …