Enable SSL in Postgresql

Enabling SSL in PostgreSQL is a straightforward process that only requires three simple steps: Make sure we have the server certificate and key files available Enable the SSL configuration (ssl = on) Make sure the pg_hba.conf file rules are updated accordingly   Obtain server certificate and key files for Postgres On PostgreSQL server, we need […]

3 ways to fix Did not find any relations in Postgresql

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 used to list all the tables in the current schema. If the command is executed […]

3 ways to get table size in Postgres

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 table in a PostgreSQL database, you can use the following SQL query: select pg_size_pretty(pg_relation_size(‘table_name’)); Replace […]

How to get the disk size of a Postgresql database

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, we will explore how to get the disk size of a database in PostgreSQL. We […]

How to get Postgresql server uptime

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 can gain valuable insights into your database’s reliability and performance, and proactively manage potential issues. […]

4 ways to get Postgresql version

As a popular and powerful open-source relational database management system, PostgreSQL is widely used in many applications. Knowing the version of PostgreSQL that you are working with is crucial for compatibility checking, troubleshooting, and ensuring that your application is utilizing the correct features and optimizations. In this post, we will explore different methods to retrieve […]