1
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
<html xmlns="http://www.w3.org/1999/xhtml">
6
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
8
<title>PostgreSQL Server installation and configuration — openerp v1 documentation</title>
9
<link rel="stylesheet" href="../../../_static/default.css" type="text/css" />
10
<link rel="stylesheet" href="../../../_static/pygments.css" type="text/css" />
11
<script type="text/javascript">
12
var DOCUMENTATION_OPTIONS = {
13
URL_ROOT: '../../../',
15
COLLAPSE_MODINDEX: false,
20
<script type="text/javascript" src="../../../_static/jquery.js"></script>
21
<script type="text/javascript" src="../../../_static/doctools.js"></script>
22
<link rel="top" title="openerp v1 documentation" href="../../../index.html" />
23
<link rel="up" title="OpenERP Installation on Linux" href="../index.html" />
24
<link rel="next" title="OpenERP Client Installation" href="../client/index.html" />
25
<link rel="prev" title="Open ERP Server Installation" href="../server/index.html" />
31
<li class="right" style="margin-right: 10px">
32
<a href="../../../genindex.html" title="General Index"
33
accesskey="I">index</a></li>
35
<a href="../client/index.html" title="OpenERP Client Installation"
36
accesskey="N">next</a> |</li>
38
<a href="../server/index.html" title="Open ERP Server Installation"
39
accesskey="P">previous</a> |</li>
40
<li><a href="../../../index.html">openerp v1 documentation</a> »</li>
41
<li><a href="../../index.html" >Installation</a> »</li>
42
<li><a href="../index.html" accesskey="U">OpenERP Installation on Linux</a> »</li>
46
<div class="document">
47
<div class="documentwrapper">
48
<div class="bodywrapper">
51
<span class="target" id="index-3"></span><div class="section" id="postgresql-server-installation-and-configuration">
52
<span id="postgresql-server-installation"></span><h1>PostgreSQL Server installation and configuration<a class="headerlink" href="#postgresql-server-installation-and-configuration" title="Permalink to this headline">¶</a></h1>
53
<div class="section" id="installing-postgresql-server">
54
<h2>Installing PostgreSQL Server<a class="headerlink" href="#installing-postgresql-server" title="Permalink to this headline">¶</a></h2>
55
<p>The <a class="reference external" href="http://www.postgresql.org/download/linux">PostgreSQL download page</a>
56
lists the available installation methods. Choose the one that suits your needs
58
<div class="section" id="example-on-ubuntu">
59
<h3>Example on Ubuntu<a class="headerlink" href="#example-on-ubuntu" title="Permalink to this headline">¶</a></h3>
60
<p>On Ubuntu, install the <strong>postgresql</strong> package:</p>
61
<div class="highlight-python"><pre>sudo apt-get install postgresql</pre>
63
<span class="target" id="index-4"></span></div>
64
<div class="section" id="setup-a-postgresql-user">
65
<h3>Setup a PostgreSQL user<a class="headerlink" href="#setup-a-postgresql-user" title="Permalink to this headline">¶</a></h3>
66
<p>When the installations of the required software are done, you have to create a
67
PostgreSQL user. Open ERP will use this user to connect to PostgreSQL.</p>
69
<div class="section" id="add-a-user">
70
<h3>Add a user<a class="headerlink" href="#add-a-user" title="Permalink to this headline">¶</a></h3>
71
<p>The default superuser for PostgreSQL is called <em>postgres</em>. We will use it below
72
as an example. If you wish to use it as well, you may need to login as this
74
<div class="highlight-python"><pre>johndoe$ sudo su - postgres
76
postgres$ createuser --createdb --no-createrole --pwprompt openuser
77
Enter password for new role: XXXXXXXXXX
78
Enter it again: XXXXXXXXXX
82
<p>, assuming you want to create the <em>openuser</em> role.</p>
83
<p>Option explanations:</p>
86
<li><tt class="docutils literal"><span class="pre">--createdb</span></tt> : the new user will be able to create new databases</li>
87
<li><tt class="docutils literal"><span class="pre">--username</span> <span class="pre">postgres</span></tt> : <em>createuser</em> will use the <em>postgres</em> user (superuser)</li>
88
<li><tt class="docutils literal"><span class="pre">--no-createrole</span></tt> : the new user will not be able to create new users</li>
89
<li><tt class="docutils literal"><span class="pre">--pwprompt</span></tt> : <em>createuser</em> will ask you the new user’s password</li>
90
<li><tt class="docutils literal"><span class="pre">openuser</span></tt> the new user’s name</li>
93
<p>You can now start the Open ERP Server. You will probably need to modify the
94
Open ERP configuration file to your need.</p>
96
<div class="section" id="case-insensitive-searches-issue">
97
<h3>Case insensitive searches issue<a class="headerlink" href="#case-insensitive-searches-issue" title="Permalink to this headline">¶</a></h3>
98
<p>For an installation which need full UTF8 character support consider to use
99
postgres >= 8.2.x. Prior to this Open ERP search will eventually not return the
100
expected results for case insensitive searches, which are used for searching
101
partners, products etc.</p>
103
<div class="highlight-python"><pre>SELECT 'x' FROM my_table WHERE 'bét' ilike 'BÉT'
104
--matches only in 8.2.x</pre>
114
<div class="sphinxsidebar">
115
<div class="sphinxsidebarwrapper">
116
<h3><a href="../../../index.html">Table Of Contents</a></h3>
118
<li><a class="reference external" href="">PostgreSQL Server installation and configuration</a><ul>
119
<li><a class="reference external" href="#installing-postgresql-server">Installing PostgreSQL Server</a><ul>
120
<li><a class="reference external" href="#example-on-ubuntu">Example on Ubuntu</a></li>
121
<li><a class="reference external" href="#setup-a-postgresql-user">Setup a PostgreSQL user</a></li>
122
<li><a class="reference external" href="#add-a-user">Add a user</a></li>
123
<li><a class="reference external" href="#case-insensitive-searches-issue">Case insensitive searches issue</a></li>
130
<h4>Previous topic</h4>
131
<p class="topless"><a href="../server/index.html"
132
title="previous chapter">Open ERP Server Installation</a></p>
134
<p class="topless"><a href="../client/index.html"
135
title="next chapter">OpenERP Client Installation</a></p>
137
<ul class="this-page-menu">
138
<li><a href="../../../_sources/install/linux/postgres/index.txt"
139
rel="nofollow">Show Source</a></li>
141
<div id="searchbox" style="display: none">
142
<h3>Quick search</h3>
143
<form class="search" action="../../../search.html" method="get">
144
<input type="text" name="q" size="18" />
145
<input type="submit" value="Go" />
146
<input type="hidden" name="check_keywords" value="yes" />
147
<input type="hidden" name="area" value="default" />
149
<p class="searchtip" style="font-size: 90%">
150
Enter search terms or a module, class or function name.
153
<script type="text/javascript">$('#searchbox').show(0);</script>
156
<div class="clearer"></div>
158
<div class="related">
161
<li class="right" style="margin-right: 10px">
162
<a href="../../../genindex.html" title="General Index"
165
<a href="../client/index.html" title="OpenERP Client Installation"
168
<a href="../server/index.html" title="Open ERP Server Installation"
170
<li><a href="../../../index.html">openerp v1 documentation</a> »</li>
171
<li><a href="../../index.html" >Installation</a> »</li>
172
<li><a href="../index.html" >OpenERP Installation on Linux</a> »</li>
176
© Copyright 2009, openerp.
177
Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 0.6.1.
b'\\ No newline at end of file'