GraphOn Support Forums
Welcome, Guest
Please Login or Register.    Lost Password?
DB: How can I copy the database from one system to another? (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: DB: How can I copy the database from one system to another?
#10
troym (Admin)
Admin
Posts: 202
graphgraph
User Online Now Click here to see the profile of this user
Gender: Male Birthdate: 1973-01-14
DB: How can I copy the database from one system to another? 5 Years, 1 Month ago Karma: 1  
This procedure was not designed for end-user use, so it is not as polished as it could be, but this is the procedure that is used by the GO-Global UX installer.

Use the provided PostgreSQL dump command:

Code:

# $(GOGLOBAL_ROOT)/postgresql/bin/pg_dump -p 4491 -u goglobalux > file
When you run this command, the output is being redirected to the file, so you don't see the prompts, but the first prompt is for a username -- type 'goglobal'. You will then be prompted for the password, which will not echo -- use 'vnOIoka23sayg2UE0'. You should then get your prompt back, and have a file called 'file' which is the dump of the database. You'll have to edit the file to remove the "Username: Password:" line at the top. Also, remove the "\connect" line. Move the dump file to the system you want to install it on. With the goglobalux product shut down (and no PostgreSQL processes running) do the following: 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. Remove any existing database:
Code:

# cd $(GOGLOBAL_ROOT) # rm -rf postgresql/data/*
2. Recreate an empty database:
Code:

# bin/gdbi -dbuser goglobal initialize setpassword start create
3. Import the database data:
Code:

# postgresql/bin/psql -U goglobal -p 4491 goglobalux < file
4. Shut down the database:
Code:

# bin/gdbi -dbuser goglobal stop
You can then restart the product using the $(GOGLOBAL_ROOT)/etc/goglobalux script. Caution should be taken to recognize that the GO-Global UX database records the numeric user and group IDs from the UNIX system for its permission database, so if corresponding user and group IDs do not exist on the target system, some icons will appear to be published incorrectly.
 
Report to moderator   Logged Logged  
 
Troy Morrison
troy @ graphon.com
GraphOn Corporation
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop