equal
deleted
inserted
replaced
109 Postgres configuration |
109 Postgres configuration |
110 ---------------------- |
110 ---------------------- |
111 |
111 |
112 .. note:: |
112 .. note:: |
113 If you already have an existing cluster and postgres server |
113 If you already have an existing cluster and postgres server |
114 running you do not require to execute the initilization step |
114 running, you do not require to execute the initilization step |
115 of your Postgres database. |
115 of your Postgres database. |
116 |
116 |
117 * First you have to initialize the database Postgres with the command ``initdb``. |
117 * First you have to initialize the database Postgres with the command ``initdb``. |
118 :: |
118 :: |
119 |
119 |
128 make sure that your username has write access on the database. |
128 make sure that your username has write access on the database. |
129 :: |
129 :: |
130 |
130 |
131 $ chown username /path/to/pgsql |
131 $ chown username /path/to/pgsql |
132 |
132 |
133 * Create a superuser for `CubicWeb` instance: :: |
133 * The database authentication can be either set to `ident sameuser` |
|
134 or `md5`. |
|
135 If set to `md5`, make sure to use an existing user |
|
136 of your database. |
|
137 If set to `ident sameuser`, make sure that your |
|
138 client's operating system user name has a matching user in |
|
139 the database. If not, please do as follow to create a user: :: |
134 |
140 |
135 $ su |
141 $ su |
136 $ su - postgres |
142 $ su - postgres |
137 $ createuser -s username |
143 $ createuser -s username |
138 |
144 |
139 Initialize the password of the superuser you just created for your |
145 If created with the options -P (for password prompt, |
140 database: :: |
146 ``createuser -s -P username``), the password will be encrypted with |
|
147 the method set in the configuration file ``pg_hba.conf``. |
|
148 If you do not use this option, then the default value will be null |
|
149 and this require to set the password in the database itself. |
|
150 To do so: :: |
141 |
151 |
142 $ su |
152 $ su |
143 $ su - postgres |
153 $ su - postgres |
144 $ psql |
154 $ psql |
145 |
155 |
148 ALTER USER username WITH PASSWORD `password` |
158 ALTER USER username WITH PASSWORD `password` |
149 |
159 |
150 This login/password will be requested when you will create an |
160 This login/password will be requested when you will create an |
151 instance with `cubicweb-ctl create` to initialize the database of |
161 instance with `cubicweb-ctl create` to initialize the database of |
152 your application. |
162 your application. |
|
163 |
|
164 .. note:: |
|
165 The authentication method can be configured in ``pg_hba.conf``. |
153 |
166 |
154 .. [XXX] Est-ce que ces etapes sont vraiment necessaires? sand : lors de l'installation de ma bdd cela n'a pas ete fait et il semble que tout aille bien. Doit etre verifie avec les experts. |
167 .. [XXX] Est-ce que ces etapes sont vraiment necessaires? sand : lors de l'installation de ma bdd cela n'a pas ete fait et il semble que tout aille bien. Doit etre verifie avec les experts. |
155 |
168 |
156 * installation of plain-text index extension :: |
169 * installation of plain-text index extension :: |
157 |
170 |