odoo@ip-172-31-3-182:~$ exit
logout
ubuntu@ip-172-31-3-182:~$ sudo su - postgres
This account is currently not available.
ubuntu@ip-172-31-3-182:~$ ubuntu@ip-172-31-3-182:~$ sudo su - postgres
This account is currently not available.sudo -u postgres psql
^C
ubuntu@ip-172-31-3-182:~$ sudo -u postgres psql
could not change directory to "/home/ubuntu": Permission denied
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
ubuntu@ip-172-31-3-182:~$ sudo nano /etc/odoo17.conf
GNU nano 6.2 /etc/odoo17.conf
[options]
admin_passwd = mxdk-uy6w-n28u
db_host = False
db_port = False
db_user = odoo1
db_password = False
xmlrpc_port = 8069
addons_path = /opt/odoo17/odoo17/addons
logfile = /var/log/odoo17/odoo17.log

[ Read 9 lines ]
^G Help ^O Write Out ^W Where Is ^K Cut ^T Execute ^C Location M-U Undo M-A Set Mark M-] To Bracket M-Q Previous
^X Exit ^R Read File ^\ Replace ^U Paste ^J Justify ^/ Go To Line M-E Redo M-6 Copy ^Q Where Was M-W Next

this is my conf

[options]
admin_passwd = mxdk-uy6w-n28u
db_host = False
db_port = False
db_user = odoo1
db_password = False
xmlrpc_port = 8069
addons_path = /opt/odoo17/odoo17/addons
logfile = /var/log/odoo17/odoo17.log

the configuration looks correct, but since xmlrpc_port is 8069 by default, you can remove this setting and check if it works without it.

You could also try adding "db_port = 5432" to tell Odoo the correct port directly