| 221 | Next, recreate the database: |
| 222 | |
| 223 | {{{ |
| 224 | createdb -E UNICODE evergreen |
| 225 | }}} |
| 226 | |
| 227 | Edit postgresql.conf in the data cluster (probably in /data/postgresql/8.3/main) and change: |
| 228 | |
| 229 | {{{ |
| 230 | checkpoint_segments = 128 |
| 231 | }}} |
| 232 | |
| 233 | This is necessary to prevent errors during the restore due to the huge side of the database. |
| 234 | |
| 235 | Finally, run: |
| 236 | |
| 237 | {{{ |
| 238 | pg_restore -d evergreen /<path_to_my_dump_file>/<dump_file> |
| 239 | }}} |
| 240 | |
| 241 | || ''' NOTE: ''' It's important not to run eg_db_config.pl if you use the -d option. This seems to cause conflicts during restore || |
| 242 | |