If you are using SQL Server Availability Group and you have multiple availability groups and instances; if you want to list Availability Group Names, Database Names, …
Read More »Faruk Erdem
What is dead.letter?
When you search for different files while working, you can see the file named dead.letter. Why does dead.letter occur? The cause of dead.letter is to …
Read More »How To Change TimeZone on 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 …
Read More »How To Change TimeZone on Centos 7
If your Linux server does not match the local time, you may experience problems when making date-based configurations. You can make mistakes due to these …
Read More »How To Create NFS Share and Mount Shared Directory on a Client On Centos
NFS is the abbreviation of the Network File System. NFS is a useful technology for file sharing. It works as a server and client …
Read More »Foreign Data Wrapper Between PostgreSQL and Oracle
In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data …
Read More »How To Install Oracle Client For PostgreSQL On Centos
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 …
Read More »make: gcc : Command not found make:*** [oracle_fdw.o] Error 127
Sometimes the standard installation is not sufficient for the extension package you want to install. The reason for this is that the extension has …
Read More »Oracle_fdw oracle_utils.c:22:17: fatal error: oci.h: No such file or directory
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 …
Read More »Universal Unique İdentifier (UUID) Data Type In PostgreSQL
Uuid is the abbreviation for “universal unique identifier”. It consists of 36 characters, a set of numbers and letters, and its most important feature …
Read More »