How to Fix: psql: FATAL: role "postgres" does not exist

Method 1: Create Role and Database

1. Step 1: Open the terminal and run the following command to create a new role:

sudo -u postgres psql

Then, type the following commands to create a new database and assign it to the newly created role:

CREATE ROLE mypostgres; CREATE DATABASE mydatabase WITH OWNER mypostgres;

Method 2: Using pg_admin

1. Step 1: Open pgAdmin and connect to your PostgreSQL server.

SELECT database_name FROM information_schema.tables WHERE table_schema = 'pg_catalog' AND table_name = 'information_schema';

This command will list all the databases in your PostgreSQL server. Then, select the 'information_schema' database and run the following commands to create a new role:

CREATE ROLE mypostgres WITH PASSWORD 'mypassword';

✨ Wrapping Up

After recreating the postgres role and database, you should be able to connect to your PostgreSQL server using the psql command.