-
How to Create Role Postgres?
I understand the importance of providing detailed information on creating roles in Postgres to help those who may be familiar with other database engines. Let’s talk abour how to create role Postgres in this article. When it comes to database management systems, the concept of a “role” in Postgres can indeed be confusing for individuals…
-
PostgreSQL Features: The Ultimate Guide
PostgreSQL is a powerful, open-source relational database management system (RDBMS) that is used by a wide variety of organizations, from small businesses to large enterprises. It is known for its scalability, flexibility, and reliability. One of the things that makes PostgreSQL so popular is its wide range of features. Here is an ultimate guide to…
-
PostgreSQL for Database Administrators
PostgreSQL is a powerful, open-source relational database management system (RDBMS) that is used by a wide variety of organizations, from small businesses to large enterprises. It is known for its scalability, flexibility, and reliability. Database administrators (DBAs) are responsible for the day-to-day management of PostgreSQL databases. This includes tasks such as creating and maintaining databases,…
-
psql: FATAL: database “user” does not exist
Hey! We are here with another common issue. TL;DR: psql -d <database_name> By default, psql client tries to connect to a database with your username. Let’s see together: In the example above, i created two users testuser1 and testuser2, defined roles for those roles to let them login. I switched to those user and tried…
-
PostgreSQL error: Fatal: role “username” does not exist
Today, we are together here for a very common error. Especially around beginners. Until you get used to PostgreSQL’s role structure and initial user configuration you will face this issue for a few times. TL;DR: su – postgres and psql Initial User Configuration Initially, only postgres user is granted to login to server. No not…
-
How to Change a PostgreSQL User Password
That command is one of the simplest and most common one around different database engines. (Excluding Db2-like Db engines, because it uses OS to validate passwords) Alter is the command we use to change / update an attribute or object in database engines. So simply, change user’s password in PostgreSQL as: Of course, you need…
-
PostgreSQL for Beginners
Hello, this is a test purpose article about PostgreSQL for beginners. PostgreSQL is a powerful, open-source relational database management system (RDBMS). It is a popular choice for a wide range of applications, including web applications, data warehousing, and big data analytics. PostgreSQL is known for its reliability, scalability, and flexibility. This blog article is designed…