So I’m having trouble connecting my postgresql db server. I’m relatively new to Ubuntu, this is a brand new computer.
My db name, username and password are all correct as per my Django settings. I hope I don’t have to edit my pg_hba.conf file.
I had similar issues regarding this with Fedora, but I didn’t think I would have this problem with Ubuntu. I did in fact create a new database via the linux terminal.
I’m also in my virtual environment. I even tried opening the psql shell and got more warnings. Here is the complete trackeback error after running python manage.py makemigrations and psql. FYI the name for my Ubuntu system is corey-james
show_sunset_warning()
/home/corey-james/Arborhub/arborhubenv/lib/python3.12/site-packages/django/core/management/commands/makemigrations.py:160: RuntimeWarning: Got an error checking a consistent migration history performed for database connection 'default': connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "cortec"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "cortec"
warnings.warn(
No changes detected
(arborhubenv) corey-james@corey-james-HP-Laptop-14-dq0xxx:~/Arborhub/MyProject$ psql
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "corey-james" does not exist
(arborhubenv) corey-james@corey-james-HP-Laptop-14-dq0xxx:~/Arborhub/MyProject$
Are you able to connect to the database at all? If so, provide the details how.
Did you create the account corey-james in PostgreSQL? (Accounts in PostgreSQL are different than system accounts.)
Other than the password, please post your DATABASES configuration.
No I didn’t an account in postgres. Here are the commands I used when creating the database, username and password.
CREATE DATABASE myproject;
CREATE USER myprojectuser WITH PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE myproject TO myprojectuser;. I replaced all three with my own configurations in settings
So other than the password, please post your DATABASES setting.
(If you don’t create an account named corey-james in the database, you’re not going to be able to connect to the database using that account name.)
If you weren’t connected to the database, how did you issue those commands to create the database and user accounts for your project?
This is the command I used to help CREATE a db in postgresql
sudo -u postgres psql
Here are my db config in settings
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql',
'NAME': 'arborcor',
'USER': 'cortec',
'PASSWORD': 'arbortec87',
'HOST': 'localhost',
'PORT': '5432', # Change this to 5432
}
}
So the commands you actually entered to set this up were:
CREATE DATABASE arborcor;
CREATE USER cortec WITH PASSWORD 'arbortec87';
GRANT ALL PRIVILEGES ON DATABASE arborcor TO cortec;
What happens if you try:
psql -h localhost -U cortec
?
This is the output from the last command
(venv) corey-james@corey-james-HP-Laptop-14-dq0xxx:~/Arborhub/MyProject$ psql -h localhost -U cortec
Password for user cortec:
psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "cortec"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "cortec"
I don’t mind deleting this database and creating a new one with the same configurations
Or just try resetting the password for that user.
Okay, I’ll try that. So the password is problem here?
So I reset my password and started the postgresql server with the following command sudo systemctl start postgresql.service.
But I still get this output
corey-james@corey-james-HP-Laptop-14-dq0xxx:~/Arborhub/MyProject$ source venv/bin/activate
(venv) corey-james@corey-james-HP-Laptop-14-dq0xxx:~/Arborhub/MyProject$ sudo systemctl start postgresql.service
[sudo] password for corey-james:
(venv) corey-james@corey-james-HP-Laptop-14-dq0xxx:~/Arborhub/MyProject$ python manage.py makemigrations
/home/corey-james/Arborhub/MyProject/venv/lib/python3.12/site-packages/drf_haystack/__init__.py:42: UserWarning:
==============================================================================
The `drf-haystack` project urgently needs new maintainers!
The current maintainers are no longer actively using drf-haystack and would
like to hand over the project to other developers who are using the package.
We will still do the bare minimum maintenance of keeping dependency references
up to date with new releases of related packages until January 1st 2026.
If by that time no new maintainers have joined to take over the project, we
will archive the project and make the repository read-only, with a final
release with whatever versions the dependencies have at that time.
This gives everyone more than a year to either consider joining as maintainers
or switch to other packages for handling their search in DRF.
Do you want to join as a maintainer? Have a look at:
<https://github.com/rhblind/drf-haystack/issues/146>
==============================================================================
show_sunset_warning()
/home/corey-james/Arborhub/MyProject/venv/lib/python3.12/site-packages/django/core/management/commands/makemigrations.py:160: RuntimeWarning: Got an error checking a consistent migration history performed for database connection 'default': connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "cortec"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "cortec"
warnings.warn(
No changes detected
That’s what the error message is telling you.
To reset the password:
alter user cortec password ‘arbortec87’;
If this doesn’t fix it, then the problem could be in one of the PostgreSQL configuration files.
1 Like
You mean pg_hfa.conf file? I’m just surprised that this happening to be honest, I didn’t think I would run into this specific problem on Ubuntu
(venv) corey-james@corey-james-HP-Laptop-14-dq0xxx:~/Arborhub/MyProject$ alter user cortec password ‘arbortek87’;
Command 'alter' not found, did you mean:
command 'qalter' from deb gridengine-client (8.1.9+dfsg-11.1)
command 'qalter' from deb slurm-wlm-torque (24.05.2-1)
Try: sudo apt install <deb name>
I’d create a new database if I knew it would fix this
The alter statement is an SQL statement similar to the create statement. It needs to be run within psql like you did to create the user.
The problem is user ‘corey-james’. I think I just want to start from scratch. I was following this tutorial to configure ngnix with my django backend How To Set Up Django with Postgres, Nginx, and Gunicorn on Ubuntu | DigitalOcean
What makes you think that’s the problem?
Your database configuration makes no mention of corey-james, nor do you make any reference to creating a user named corey-james in the database.
Keep in mind that your database users have no direct relationship to your operating system users. Do not confuse or conflate the two.
Yes, I understand the distinction. My OS name is corey-james and my postgresql user is different.
Having said that, after showing you the tutorial I was following, what should I do?
Let’s be clear on exactly which problem you’re trying to address. You’ve shown a couple different commands with different errors.
To avoid further confusion, pick one, and let’s get that resolved before looking at anything else.