Re: [Gnumed-devel] Re: problems to restore DB in Debian Testing

[Rogerio Luz Coelho]

Ok I know this post is old but on a new Debian Testing instalation the steps to be able to restore the DB are as follows: 

As root; 

1) Add postgres do sudoers list 
# visudo

Add the following line beneath 'root ALL=(ALL) ALL'
postgres ALL=(ALL) ALL 

*** Be aware that now postgres IS for all purposes a root on your machine. 

2) Change to postgres user 
# su postgres

3) Copy the DB you want to restore to postgres "home" folder
# cp /backuped-DB.tar.bz2 ~/

4) Run the restore script
# gm-restore_dabase  ~/backuped-DB.tar.bz2 

5) "su" to root and REMOVE the postgres form the sudoers list by "visudo"



Then it does sucessfully restore a DB :) 

Rogerio 

PS: have no time to debug this or post it to the wiki :)