3
.. i18n: single: Installation; Windows installation quirks
8
single: Installation; Windows installation quirks
11
.. i18n: .. _troubleshooting-and-windows-complementary-install-information:
13
.. i18n: Troubleshooting and Windows Complementary Install Information
14
.. i18n: =============================================================
17
.. _troubleshooting-and-windows-complementary-install-information:
19
Troubleshooting and Windows Complementary Install Information
20
=============================================================
22
.. i18n: PostgreSQL Administration
23
.. i18n: +++++++++++++++++++++++++
26
PostgreSQL Administration
27
+++++++++++++++++++++++++
29
.. i18n: OpenERP Server Connection Error with PostgreSQL
30
.. i18n: """""""""""""""""""""""""""""""""""""""""""""""
33
OpenERP Server Connection Error with PostgreSQL
34
"""""""""""""""""""""""""""""""""""""""""""""""
36
.. i18n: 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.
37
.. i18n: Otherwise you may encounter error messages as shown below:
40
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.
41
Otherwise you may encounter error messages as shown below:
43
.. i18n: .. figure:: ../../img/user_fail.png
45
.. i18n: :align: center
48
.. figure:: ../../img/user_fail.png
52
.. i18n: *User authentication failure*
55
*User authentication failure*
57
.. i18n: You may also face another problem similar to this situation:
60
You may also face another problem similar to this situation:
62
.. i18n: .. figure:: ../../img/101_erp2pgsql_conn_fail.png
64
.. i18n: :align: center
67
.. figure:: ../../img/101_erp2pgsql_conn_fail.png
71
.. i18n: *Database connection failure*
74
*Database connection failure*
76
.. i18n: In this case, check if the service ``postgresql-9.0 - PostgreSQL Server 9.0`` is running in the Services Manager (:menuselection:`Control Panel --> System and Security --> Administrative Tools --> Services`).
79
In this case, check if the service ``postgresql-9.0 - PostgreSQL Server 9.0`` is running in the Services Manager (:menuselection:`Control Panel --> System and Security --> Administrative Tools --> Services`).
81
.. i18n: .. figure:: ../../img/Pgsql_51_service_status.png
83
.. i18n: :align: center
86
.. figure:: ../../img/Pgsql_51_service_status.png
90
.. i18n: *PostgreSQL 9.0 in the Services list*
93
*PostgreSQL 9.0 in the Services list*
95
.. i18n: You can edit the service configuration to start PostgreSQL as a service on system boot. This is usually the default.
98
You can edit the service configuration to start PostgreSQL as a service on system boot. This is usually the default.
100
.. i18n: .. figure:: ../../img/Pgsql_53_service_start_mode.png
102
.. i18n: :align: center
105
.. figure:: ../../img/Pgsql_53_service_start_mode.png
109
.. i18n: *Configure PostgreSQL 9.0 service*
112
*Configure PostgreSQL 9.0 service*
114
.. i18n: If your PostgreSQL service is running, but you get connection errors, you can restart the service.
117
If your PostgreSQL service is running, but you get connection errors, you can restart the service.
119
.. i18n: .. figure:: ../../img/Pgsql_52_service_restart.png
121
.. i18n: :align: center
124
.. figure:: ../../img/Pgsql_52_service_restart.png
128
.. i18n: *Restarting the service*
131
*Restarting the service*