3
single: Installation; PostgreSQL
4
single: PostgreSQL; Installation
7
.. _postgresql-server-installation:
9
PostgreSQL Server installation and configuration
10
================================================
12
Installing PostgreSQL Server
13
----------------------------
15
The `PostgreSQL download page <http://www.postgresql.org/download/linux>`__
16
lists the available installation methods. Choose the one that suits your needs
22
On Ubuntu, install the **postgresql** package: ::
24
sudo apt-get install postgresql
27
single: PostgreSQL; setup a user
28
single: PostgreSQL; setup a database
31
Setup a PostgreSQL user
32
+++++++++++++++++++++++
34
When the installations of the required software are done, you have to create a
35
PostgreSQL user. Open ERP will use this user to connect to PostgreSQL.
40
The default superuser for PostgreSQL is called *postgres*. We will use it below
41
as an example. If you wish to use it as well, you may need to login as this
44
johndoe$ sudo su - postgres
46
postgres$ createuser --createdb --no-createrole --pwprompt openuser
47
Enter password for new role: XXXXXXXXXX
48
Enter it again: XXXXXXXXXX
52
, assuming you want to create the *openuser* role.
56
* ``--createdb`` : the new user will be able to create new databases
57
* ``--username postgres`` : *createuser* will use the *postgres* user (superuser)
58
* ``--no-createrole`` : the new user will not be able to create new users
59
* ``--pwprompt`` : *createuser* will ask you the new user's password
60
* ``openuser`` the new user's name
62
You can now start the Open ERP Server. You will probably need to modify the
63
Open ERP configuration file to your need.
65
.. tip:: You can find information on configuration files in the Developer Book,
66
section :ref:`Configuration <configuration-files-link>`
68
Case insensitive searches issue
69
+++++++++++++++++++++++++++++++
71
For an installation which need full UTF8 character support consider to use
72
postgres >= 8.2.x. Prior to this Open ERP search will eventually not return the
73
expected results for case insensitive searches, which are used for searching
74
partners, products etc.
78
SELECT 'x' FROM my_table WHERE 'bét' ilike 'BÉT'
79
--matches only in 8.2.x