PostgreSQL AWR
In PostgreSQL, you may need to review more than one thing to analyze database or whole cluster when you encounter
Category: PostgreSQL
How To Configure postgresql.conf Using pgtune
PostgreSQL is a database management system that is bare when it is first installed. Therefore, you should make some configurations
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
PostgreSQL – psql – gexec
As database administrators or software developers, we sometimes write sqls that produce sqls. We save the output to the file.
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
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
PostgreSQL Streaming Replication
Master Server / Primary Server Set Up 1. Configuration Changes in file “postgresql.conf“
|
1 2 3 4 5 6 7 8 |
listen_address=* port=5432 wal_level=hot_standby max_wal_senders=3 wal_keep_segments=32 hot_standby=on archive_mode=on archive_command='cp %p /usr/local/archive/%f' |
2. Configuration Changes in
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
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
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