PostgreSQL

  Sometimes we may want to create the same table in a database without the data in it by using a different name or we …

  You are processing in psql, but you need to look at something on the operating system side, so you must exit from the psql …

  You can use the following command to see the list of tablespaces created. [crayon-67428636d4d01950318380/]   You can also use the following script to list …

  There are countless ways of understanding how long PostgreSQL has been turned on. In this article we will talk about 3 methods.   1)Using …

  As you know, at the end of September 2016, PostgreSQL version 9.6 was released. In this article you will find the installation steps of …

Create Extension First, if the extension is not present, it is created with the following command. [crayon-67428636d52a2774966065/] The functions we will use; [crayon-67428636d52a6828063944/] Example: We …

  In this article I will share some monitoring scripts about postgresql.   To Check if the Postgresql service is running via OS(linux): [crayon-67428636d54b4915892007/]   …

  We may need to keep passwords in databases for some reason, and we don’t want anyone to see them, including dba. In postgresql there …

  This article is the second article of the performance series. You can find the first articles link “POSTGRESQL DATABASE PERFORMANCE – 1” In the …

  If we examine some performance parameters in postgresql, I will mention a few parameters that will be quite useful for performance. You can configure …