Changes between Version 9 and Version 10 of sysadminPostgreSQLConfiguration

Timestamp:

Jun 23, 2009, 6:14:33 PM (14 years ago)

Author:

risard

Comment:

--

sysadminPostgreSQLConfiguration

@@ -177 +177 @@
 
   || ''' 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 ||
-    
-     
+  
+You should now have a clean install of the Evergreen schema loaded with the "example consortium."
+
+=== Restoring From A Dump File ===
+
+It Open-ils is running stop it first.
+
+Then, doing the following as the postgres user:
+
+{{{
+    su postgres
+}}}    
+
+In psql:
+
+{{{
+    drop database evergreen;
+}}}     
+
+check to see that there's an evergreen user before rebuilding the server.  In psql, display the users:
+
+{{{
+    psql# \du
+}}}
+
+if you don't see an evergreen user:
+
+{{{
+                                   List of roles
+     Role name | Superuser | Create role | Create DB | Connections | Member of
+    -----------+-----------+-------------+-----------+-------------+-----------
+    evergreen  | yes       | yes         | yes       | no limit    | {}
+    postgres   | yes       | yes         | yes       | no limit    | {}
+(2 rows)
+}}}
+
+then create the evergreen user with:
+
+{{{
+createuser -P -s evergreen
+}}}
+