The error “could not load server certificate file ‘server.crt’: No such file or directory” in PostgreSQL indicates that the server is unable to find the server.crt file, which is required for SSL connections. If you don’t need that, set “ssl…
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…
Preserve file permissions using -p option in cp command To preserve the file permissions when copying files or directories using the cp command, you can use the -p or –preserve option. The -p option will preserve the following attributes of…
The error message “cp: Permission denied” typically occurs when the user doesn’t have permission to access the source file or the destination directory. Here are the errors we usually meet with “cp Permission denied” error in Linux: Error Description cp:…
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…
Create a file with Ansible file module There are a few ways to create a file with Ansible. One way is to use the file module. The file module has a state option that can be set to touch to…
Some tasks may consume a significant amount of system resources, such as CPU or memory, and running too many of these tasks at once can cause performance issues. By adding a pause between loop iterations, you can help to manage…
selectattr in Ansible selectattr is a filter plugin in Ansible that allows you to select a subset of elements from a list of dictionaries based on the value of a particular attribute. Its syntax is as follows: <list of dictionaries>…
This article is part of the following series. Get MAC address with Ansible You can use the ansible_default_ipv4.macaddress variable to get the MAC address using Ansible.This is a variable that contains the MAC address of default network interface. Here…
