Enabling SSL in PostgreSQL is a straightforward process that only requires three simple steps: Obtain server certificate and key files for Postgres On PostgreSQL server, we need 3 certificates in data directory for SSL configuration. They are: In…
When running the \dt command in PostgreSQL, the error message “Did not find any relations” means that no tables were found in the current schema that is visible to the user running the command. In PostgreSQL, the \dt command is…
Get table size with pg_relation_size in Postgres PostgreSQL provides a dedicated function, pg_relation_size, to compute the actual disk space used by a specific table or index. We just need to provide the table name. To check the size of a…
If you’re a PostgreSQL user or developer, you may often need to monitor the size of your database to manage storage resources efficiently. One crucial aspect of this monitoring is checking the disk size of your database. In this post,…
In this post, we will delve into the concept of PostgreSQL server uptime, why it matters, and how to accurately measure it using SQL queries and built-in functions. By understanding how to obtain the uptime of a PostgreSQL server, you…
As a popular and powerful open-source relational database management system, PostgreSQL is widely used in many applications. In this post, we will explore different methods to retrieve the PostgreSQL version information. We will cover SQL queries that can be executed…
