Odoo 15启动服务器及创建数据库时遭遇psycopg2.OperationalError问题求助

Hey there, let's work through this database connection problem you're hitting with Odoo 15. From the logs and config you shared, this is almost always related to PostgreSQL not being accessible to Odoo for one reason or another. Here's a step-by-step breakdown to fix it:

1. Make Sure PostgreSQL Service is Running #

First things first—Odoo can't connect if PostgreSQL isn't even up. On Windows:

• Press Win + R, type services.msc and hit Enter.
• Look for the PostgreSQL service (it'll be named something like postgresql-x64-14 depending on your installed version; Odoo 15 works best with PostgreSQL 12-14).
• Check if its status is Running. If not, right-click it, select "Start", and set its startup type to "Automatic" so it launches on boot.

2. Verify PostgreSQL's Listening Port & Access Rules #

Check Port Listening #

Open Command Prompt and run this command to confirm PostgreSQL is listening on port 5432:

netstat -ano | findstr :5432

You should see a line with LISTENING status. If not, check your PostgreSQL postgresql.conf file (in the data folder of your PostgreSQL installation) and ensure port = 5432 is set, then restart the service.

Update pg_hba.conf for Local Access #

PostgreSQL uses the pg_hba.conf file to control who can connect. Open this file (same data folder as above) and add or modify this line to allow your odoo15 user to connect from localhost:

host    all             odoo15          127.0.0.1/32          scram-sha-256

(Note: If you're using an older PostgreSQL version, replace scram-sha-256 with md5)
Save the file and restart the PostgreSQL service to apply changes.

3. Confirm Database User & Credentials Are Correct #

Odoo needs a valid PostgreSQL user with permission to create databases. Let's verify:

• Open the PostgreSQL command line (or use pgAdmin) and log in as the postgres superuser.
• Check if the odoo15 user exists:

  SELECT usename FROM pg_user;
  

• If it doesn't exist, create it with the right permissions:

  CREATE USER odoo15 WITH PASSWORD '0000' CREATEDB;
  

• Test the credentials directly: Run this in Command Prompt to see if you can connect with the user/password from your config:

  psql -U odoo15 -d postgres -h localhost
  

  Enter your password 0000—if this fails, you know the credentials are the problem.

4. Double-Check Odoo Config (odoo.conf) #

Make sure your odoo.conf settings match PostgreSQL's setup exactly:

• Confirm db_host = localhost (unless you changed PostgreSQL's listening address)
• Ensure db_port = 5432 matches the port PostgreSQL is using
• Verify db_user = odoo15 and db_password = 0000 are correct (no typos!)
• db_name = False is correct here—it just means Odoo won't connect to a specific database on startup, which is normal for the initial setup.

5. Test psycopg2 Connection Directly #

To rule out Odoo-specific issues, create a simple Python script to test psycopg2:

import psycopg2

try:
    conn = psycopg2.connect(
        host="localhost",
        database="postgres",
        user="odoo15",
        password="0000",
        port="5432"
    )
    print("Connection successful! PostgreSQL is accessible.")
    conn.close()
except psycopg2.OperationalError as e:
    print(f"Connection failed with error: {e}")

Run this script—if it fails, the error message will tell you exactly what's wrong (e.g., password mismatch, server not reachable).

9 times out of 10, one of these steps will fix the issue. Let me know if you hit any specific errors while going through this!

内容的提问来源于stack exchange，提问作者Anas Raghib