equal
deleted
inserted
replaced
107 .. _ConfigurationPostgres: |
107 .. _ConfigurationPostgres: |
108 |
108 |
109 Postgres configuration |
109 Postgres configuration |
110 ---------------------- |
110 ---------------------- |
111 |
111 |
|
112 .. note:: |
|
113 If you already have an existing cluster and postgres server |
|
114 running you do not require to execute the initilization step |
|
115 of your Postgres database. |
|
116 |
112 * 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``. |
113 :: |
118 :: |
114 |
119 |
115 $ initdb -D /path/to/pgsql |
120 $ initdb -D /path/to/pgsql |
116 |
121 |
123 make sure that your username has write access on the database. |
128 make sure that your username has write access on the database. |
124 :: |
129 :: |
125 |
130 |
126 $ chown username /path/to/pgsql |
131 $ chown username /path/to/pgsql |
127 |
132 |
128 * Create a superuser for `CubicWeb` instance (**root**) :: |
133 * Create a superuser for `CubicWeb` instance: :: |
|
134 |
|
135 $ su |
|
136 $ su - postgres |
|
137 $ createuser -s username |
129 |
138 |
130 createuser -s username |
139 Initialize the password of the superuser you just created for your |
|
140 database: :: |
|
141 |
|
142 $ su |
|
143 $ su - postgres |
|
144 $ psql |
131 |
145 |
132 Initialize the password of the superuser you just created with |
146 And then execute de following query: :: |
133 ``su - postgres`` and ``psql``. |
147 |
|
148 ALTER USER username WITH PASSWORD `password` |
134 |
149 |
135 This password will be asked to you later on where you will create an |
150 This login/password will be requested when you will create an |
136 instance with `cubicweb-ctl create` |
151 instance with `cubicweb-ctl create` to initialize the database of |
|
152 your application. |
137 |
153 |
138 .. [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. |
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. |
139 |
155 |
140 * installation of plain-text index extension :: |
156 * installation of plain-text index extension :: |
141 |
157 |