How to get a copy of MIPP DB on your local server


The procedure is quite simple once you actually can connect to the database. The following sequence of commands will do the job. Substitute DB with db name (acnet, batchproc, calib, cmap, rich, slowmon, test). Note that I run commands as user postgres on the local server.
  1. Remove existing database, so you start with a clean location 
     dropdb -U postgres -h your.server DB
  2. Create the database 
     createdb -U postgres -h your.server -E SQL_ASCII DB
    Note: SQL_ASCII encoding is default for mippsrv01 DB, while UTF8 is default on Postgres 8.1 (or maybe others). Currently, runs DB cannot be copied with UTF8 encoding. If you figure out how to do it, let me know.
  3. Dump DB from MIPP server into your installation 
     pg_dump DB -U mippdbread -h mippsrv01 | psql DB -h your.server -U postgres
Let me know if this doesn't work for your installation.

Andre Lebedev $Date: 2006/07/24 18:55:12 $