The RHCSA (Red Hat Certified System Administrator) exam is a performance-based certification exam offered by Red Hat. It is designed to validate the skills and knowledge required to effectively administer Red Hat Enterprise Linux systems in various enterprise environments. The RHCSA certification is highly recognized in the IT industry and serves as a benchmark for …
This article is part of the following series. 4 Ways to Find network interfaces in Linux 5 useful Linux network troubleshooting commands 3 Easy Ways to Find IP address in Linux 3 Ways to Find MAC Address In Linux Understanding MAC address in Linux In Linux, a MAC address (Media Access Control address) is …
There are a few different ways to search files by size in Linux. One way is to use the find command. The find command is a powerful tool that can be used to search for files based on a variety of criteria, including size. Search files by size in Linux To search for files by …
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 = off”, then PostgreSQL won’t complain. If you want transport encryption with TLS, you have …
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 …
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 source file or directory: File mode (permissions) Access time Modification time User ID (UID) …
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: cannot create regular file ‘destination/path’: Permission denied Indicates that the user does not have permission …
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 …
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 …
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 create a new file. Description path The path of the file that needs to …