This is the documentation for older versions of Odoo (formerly OpenERP).

See the new Odoo user documentation.

See the new Odoo technical documentation.

Troubleshooting and Windows Complementary Install Information

PostgreSQL Administration

OpenERP Server Connection Error with PostgreSQL

If you are initializing a database from the command-line with a custom username/role (-r) and password (-w), ensure that you have created a corresponding PostgreSQL user for the same. Otherwise you may encounter error messages as shown below:

/doc_static/7.0/_images/user_fail.png

User authentication failure

You may also face another problem similar to this situation:

/doc_static/7.0/_images/101_erp2pgsql_conn_fail.png

Database connection failure

In this case, check if the service postgresql-9.0 - PostgreSQL Server 9.0 is running in the Services Manager (Control Panel ‣ System and Security ‣ Administrative Tools ‣ Services).

/doc_static/7.0/_images/Pgsql_51_service_status.png

PostgreSQL 9.0 in the Services list

You can edit the service configuration to start PostgreSQL as a service on system boot. This is usually the default.

/doc_static/7.0/_images/Pgsql_53_service_start_mode.png

Configure PostgreSQL 9.0 service

If your PostgreSQL service is running, but you get connection errors, you can restart the service.

/doc_static/7.0/_images/Pgsql_52_service_restart.png

Restarting the service