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 »
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 »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 »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 »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 »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 »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 »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 »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 »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 »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 »