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

[Karsten Hilbert]

Hello Rogerio,

thanks for your restore report !

I have just now restored a v14 database across machines from
a standard GNUmed backup using the standard GNUmed restore
script and it worked just fine when run as root.

Karsten

On Fri, Oct 01, 2010 at 08:46:58PM -0300, Rogerio Luz Coelho wrote:

> 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 :)

> _______________________________________________
> Gnumed-devel mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/gnumed-devel


-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346