Re: [Gnumed-devel] BACKUP / RESTORE

[Rogerio Luz]

Finally made a backup of the hole DB 

But when trying to restore still can´t make it work. Complains about the DB already being active, AND I can´t "dropdb gnumed_v9" (wich I guess is a good thing :) 

so here goes the terminal exit: 

--------------------------------------

/home/rogerio/GNUmed/GNUmed-v9/server# sh gm-restore_database.sh /home/rogerio/Desktop/backup-gnumed_v9-GNUmed_Team-casa-deb-2008-10-28-15-11-55.tar.bz2 

==> Trying to restore GNUmed backup ...
    file: /home/rogerio/Desktop/backup-gnumed_v9-GNUmed_Team-casa-deb-2008-10-28-15-11-55.tar.bz2

==> Reading configuration ...
    file: /etc/gnumed/gnumed-restore.conf

==> Testing backup file integrity ...
  /home/rogerio/Desktop/backup-gnumed_v9-GNUmed_Team-casa-deb-2008-10-28-15-11-55.tar.bz2: 
    [1: huff+mtf rt+rld]
    [2: huff+mtf rt+rld]
    [3: huff+mtf rt+rld]
    [4: huff+mtf rt+rld]
    ok

==> Setting up workspace ...
mkdir: pasta `/root/gnumed/gm-restore-2008-10-28-15-41-41/' criada

==> Creating copy of backup file ...
`/home/rogerio/Desktop/backup-gnumed_v9-GNUmed_Team-casa-deb-2008-10-28-15-11-55.tar.bz2' -> `/root/gnumed/gm-restore-2008-10-28-15-41-41/backup-gnumed_v9-GNUmed_Team-casa-deb-2008-10-28-15-11-55.tar.bz2'

==> Unpacking backup file ...
  /root/gnumed/gm-restore-2008-10-28-15-41-41//backup-gnumed_v9-GNUmed_Team-casa-deb-2008-10-28-15-11-55.tar.bz2: 
    [1: huff+mtf rt+rld]
    [2: huff+mtf rt+rld]
    [3: huff+mtf rt+rld]
    [4: huff+mtf rt+rld]
    done
-rw-r--r-- root/root   2885762 2008-10-28 15:12 backup-gnumed_v9-GNUmed_Team-casa-deb-2008-10-28-15-11-55-database.sql
-rw-r--r-- root/root      4965 2008-10-28 15:11 backup-gnumed_v9-GNUmed_Team-casa-deb-2008-10-28-15-11-55-roles.sql

==> Adjusting GNUmed roles ...

   You will now be shown the roles backup file.
   Please edit it to only include the roles you need for GNUmed.

   Remember that in PostgreSQL scripts the comment marker is "--".

   Press <ENTER> to continue.

==> Checking for existence of target database gnumed_v9 ...
    ERROR: database gnumed_v9 already exists, aborting
---------------------------------------------------

What am I doing wrong now ?

 ;) and besides, IF I let all the roles in there will it be much of a problem? I guess I need only "any-doc" "gm-dbo" and "rogluz" (my account) and all the "gnumed_vX" roles ?? 

Rogerio