179 | | |
180 | | |
| 179 | |
| 180 | You should now have a clean install of the Evergreen schema loaded with the "example consortium." |
| 181 | |
| 182 | === Restoring From A Dump File === |
| 183 | |
| 184 | It Open-ils is running stop it first. |
| 185 | |
| 186 | Then, doing the following as the postgres user: |
| 187 | |
| 188 | {{{ |
| 189 | su postgres |
| 190 | }}} |
| 191 | |
| 192 | In psql: |
| 193 | |
| 194 | {{{ |
| 195 | drop database evergreen; |
| 196 | }}} |
| 197 | |
| 198 | check to see that there's an evergreen user before rebuilding the server. In psql, display the users: |
| 199 | |
| 200 | {{{ |
| 201 | psql# \du |
| 202 | }}} |
| 203 | |
| 204 | if you don't see an evergreen user: |
| 205 | |
| 206 | {{{ |
| 207 | List of roles |
| 208 | Role name | Superuser | Create role | Create DB | Connections | Member of |
| 209 | -----------+-----------+-------------+-----------+-------------+----------- |
| 210 | evergreen | yes | yes | yes | no limit | {} |
| 211 | postgres | yes | yes | yes | no limit | {} |
| 212 | (2 rows) |
| 213 | }}} |
| 214 | |
| 215 | then create the evergreen user with: |
| 216 | |
| 217 | {{{ |
| 218 | createuser -P -s evergreen |
| 219 | }}} |
| 220 | |