PostgreSQL

If you get the error “pg_restore archiver unsupported version” while restoring, most propably it is because of the version. You may get this error because the version on the server …

Sometimes you may need to connect to postgresql from command line in windows. In this article, I will show you how to do this. First, psql must be installed on …

In order to find long running queries in PostgreSQL, we can set the log_min_duration_statement parameter in the postgresql.conf file to a certain threshold value and ensure that the queries that …

What is PostGIS in PostgreSQL? It would not be wrong to say that PostGIS is an open source software program that supports geometrical features for object relational database. We use …

In this article, we will install PostgreSQL 12 On Centos 8. We choose the versions we will install by going to the link below. https://www.postgresql.org/download/linux/redhat/ Let’s do these steps by …

We will perform REPMGR installation and configuration for postgresql in this article. You can see our environments. pg is our primary postgresql cluster and the others are our standbys Machine …

Today, I will introduce you a nice extension that we can use instead of VACUUM FULL in PostgreSQL. I recommend using it in your prod environments. VACUUM FULL command rewrites …

This article contains information about revoke command usage in PostgreSQL. You may want to revoke permissions of users. In this case, you can use the plpgsql commands below. First, let’s …

What is Barman? Barman is an open source backup / restore management tool in PostgreSQL. What can you do with Barman? You can create backups on the same server. You …

In this article, we will upgrade PostgreSQL 11 to 12. If you want to upgrade PostgreSQL 10 to 11 you should read the article “Upgrade PostgreSQL 10 to 11” PostgreSQL …