Changes between Version 10 and Version 11 of sysadminPostgreSQLConfiguration


Ignore:
Timestamp:
Jun 23, 2009, 6:22:04 PM (13 years ago)
Author:
risard
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • sysadminPostgreSQLConfiguration

    v10 v11  
    219219}}}
    220220
     221Next, recreate the database:
     222
     223{{{
     224    createdb -E UNICODE evergreen
     225}}}
     226
     227Edit postgresql.conf in the data cluster (probably in /data/postgresql/8.3/main) and change:
     228
     229{{{
     230    checkpoint_segments = 128
     231}}}
     232
     233This is necessary to prevent errors during the restore due to the huge side of the database.
     234
     235Finally, 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