PostgreSQL is a database management system that is bare when it is first installed. Therefore, you should make some configurations according to your system resorce. To …
Read More »PostgreSQL
How To Grant Permission On Foreign Data Wrapper
We can read data from Oracle or MSSQL with the help of PostgreSQL Foreign Data Wrapper. Please read the following articles for installation and detailed …
Read More »PostgreSQL – psql – gexec
As database administrators or software developers, we sometimes write sqls that produce sqls. We save the output to the file. Then we run this file …
Read More »PostgreSQL – format sql with pgFormatter
pgFormatter can format a SQL file according to the options. It can also be used as a CGI. Also is simple to use. The basic …
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 »PostgreSQL Streaming Replication
Master Server / Primary Server Set Up 1. Configuration Changes in file “postgresql.conf“ [crayon-676bb57bbd166408047155/] 2. Configuration Changes in file “pg_hba.conf” Make an entry …
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 »