Changes between Version 9 and Version 10 of sysadminPostgreSQLConfiguration


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

--

Legend:

Unmodified
Added
Removed
Modified
  • sysadminPostgreSQLConfiguration

    v9 v10  
    177177
    178178  || ''' NOTE: ''' this script uses opensrf.xml to figure out where the db server is, so it's important to have already configured opensrf to run Evergreen before running this script ||
    179    
    180      
     179 
     180You should now have a clean install of the Evergreen schema loaded with the "example consortium."
     181
     182=== Restoring From A Dump File ===
     183
     184It Open-ils is running stop it first.
     185
     186Then, doing the following as the postgres user:
     187
     188{{{
     189    su postgres
     190}}}   
     191
     192In psql:
     193
     194{{{
     195    drop database evergreen;
     196}}}     
     197
     198check to see that there's an evergreen user before rebuilding the server.  In psql, display the users:
     199
     200{{{
     201    psql# \du
     202}}}
     203
     204if 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
     215then create the evergreen user with:
     216
     217{{{
     218createuser -P -s evergreen
     219}}}
     220