Welcome, Guest
Please Login or Register.    Lost Password?

DB: How can I reinitialize the database?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: DB: How can I reinitialize the database?
#13
DB: How can I reinitialize the database? 14 Years, 1 Month ago Karma: 2
As root, perform the following steps:

0. Set your ${GOGLOBAL_ROOT} environment variable, using a command similar to one of these (depending on your shell):

Code:

# export GOGLOBAL_ROOT=/usr/local/graphon (bash/ksh)
# setenv GOGLOBAL_ROOT /usr/local/graphon (csh)
# GOGLOBAL_ROOT=/usr/local/graphon; export GOGLOBAL_ROOT (sh)



1. Move to the base directory of the GO-Global UX installation:

Code:

# cd ${GOGLOBAL_ROOT}


2. Shut down the GO-Global UX product:

Code:

# etc/goglobalux stop


3. Verify that no "postmaster" or "postgres" processes are running on the system.

Code:

# ps -eaf | grep post 


4. Remove the old database files:

Code:

# rm -rf postgresql/data/*


5. Run the 'gdbi' (GO-Global Database Initialization) command, making sure to specify the correct username and port:

Code:

# bin/gdbi -dbuser <user> -dbport <port>

Example using defaults:
Code:

# bin/gdbi -dbuser goglobal -dbport 4491


6. Restart the GO-Global UX system:

Code:

# etc/goglobalux start


Your database is now reinitialized.
troy
Administrator
Posts: 231
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Birthday: 01/14
Last Edit: 2008/03/18 15:42 By troy.
The administrator has disabled public write access.
 
Go to topPage: 1
Moderators: troy, Andyl