CreateDB: Error: Local user with ID 1001 does not exists
Learn how to fix the "could not connect to database" error in PostgreSQL by executing the command as the user 'postgres'.
Solution
If you encounter the error "createDB: Error: Local user with ID 1001 does not exists" while trying to create a new database in PostgreSQL, follow these steps to fix the issue:
Execute the command as the user postgres instead of your current user. For example, to create a new database named chirpns, run:
createdb -U postgres chirpns
This command creates a new database named chirpns with the user postgres as the owner. You can replace chirpns with the name of your desired database.
Note: If you don't know the password for the postgres user, you can reset it by running:
sudo -u postgres psql \password postgres
This will prompt you to enter a new password for the postgres user.
