Changes between Version 19 and Version 20 of sysadminPostgreSQLConfiguration
- Timestamp:
- Jun 24, 2009, 9:26:09 AM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
sysadminPostgreSQLConfiguration
v19 v20 321 321 322 322 #now configure postgresql.conf as per the file snippet at the end of these instructions 323 324 323 #start the database: 325 324 … … 331 330 #### CREATE THE EVERGREEN DATABASE #### 332 331 333 ### from source###332 ### FROM SOURCE ### 334 333 335 334 su postgres 336 335 createuser -P -s evergreen 337 338 336 createdb -E UNICODE evergreen 339 337 createlang plperl evergreen … … 343 341 psql -f /usr/share/postgresql/8.3/contrib/tsearch2.sql evergreen 344 342 psql -f /usr/share/postgresql/8.3/contrib/pgxml.sql evergreen 345 346 343 perl Open-ILS/src/support-scripts/eg_db_config.pl --create-schema #run on the oils server with oils running 347 344 348 345 349 ### from a dump file###346 ### FROM A DUMP FILE ### 350 347 351 348 #stop oils … … 354 351 su postgres 355 352 psql# drop database evergreen; 356 357 #check if evergreen user is still there358 psql# \du359 360 #if not, create it:361 362 353 createuser -P -s evergreen 363 364 #create db365 366 354 createdb -E UNICODE evergreen 367 355 368 356 #edit postgresql.conf checkpoint_segments (see file snippet) 369 370 357 #start the restore 371 358 … … 378 365 ANALYZE 379 366 367 380 368 #### INSTALL JSON::XS #### 381 369 … … 386 374 apt-get update 387 375 apt-get install gcc 388 389 376 perl -MCPAN -e 'CPAN::Shell?install(“JSON::XS”)' 390 377