First of all, we must install PostgreSQL on Primary Server and perform initdb operations. You can find out how to do this in the article …
Read More »PostgreSQL
What is PgBackRest and PgBackRest Installation in PostgreSQL 12
What is pgBackRest pgBackRest is a backup/restore tool in postgresql. PostgreSQL Backup Types In Postgresql, we create backups in two ways: logical and physical. Logical …
Read More »How To Change Column’s Data Type in PostgreSQL
Suppose that we created a table in the database by following the normalization rules for our application. However, we realized that the data type of …
Read More »FATAL: lock file already exists
You may receive this error when there are multiple IPs on the same server that use the same port. In this case, you cannot run …
Read More »How To Create a Linked Server To Connect To PostgreSQL From SQL Server
You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different methods to perform this. One …
Read More »How To Install Check_postgres On Centos(Monitoring Tool)
Check_postgres is a tool you can use to monitor PostgreSQL. You can download from the link below. https://github.com/bucardo/check_postgres If you downloaded it in zip format, …
Read More »How To Create PostgreSQL Repository To Install Postgres Without Internet
Download Postgres Repository Metadata First, Run the below command on a server that can connect to internet. This command download the latest postgres repository metadata …
Read More »PostgreSQL AWR
In PostgreSQL, you may need to review more than one thing to analyze database or whole cluster when you encounter a problem. For example, a …
Read More »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 according to your system resorce. To …
Read More »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 »