Re: [Gnumed-devel] Restoring a database under Debian

[Busser, Jim]

On 2015-01-14, at 9:21 PM, Jim Busser <address@hidden> wrote:

> which log says only
> 
>       
> /root/gnumed/gm-restore_2015-01-14_20-59-11/backup-gnumed_v19-GNUmed_Team-dhcp-128-189-241-105.ubcsecure.wireless.ubc.ca-2015-01-12-09-59-25-roles.sql:
>  Permission denied
> 
> which feels strange because the permissions in the directory
> 
>       /root/gnumed/gm-restore_2015-01-14_20-59-11/
> 
> seem to be in order...
> 
>       drwxr-xr-x 2 root     root      4096 Jan 14 20:59 .
>       drwxr-xr-x 3 root     root      4096 Jan 14 20:59 ..
>       -rw-r--r-- 1 postgres  503 383338223 Jan 12 10:00 
> backup-gnumed_v19-GNUmed_Team-dhcp-128-189-241-105.ubcsecure.wireless.ubc.ca-2015-01-12-09-59-
> 25-database.sql
> -rw-r--r-- 1 postgres  503       527 Jan 14 21:00 
> backup-gnumed_v19-GNUmed_Team-dhcp-128-189-241-105.ubcsecure.wireless.ubc.ca-2015-01-12-09-59-25-roles.sql
> 
> ??

but maybe the problem is at the level of the directory that *encloses* the 
above .sql files:

        drwxr-xr-x 3 root root 4096 Jan 14 20:59 .
        drwx------ 5 root root 4096 Jan 14 20:59 ..
        drwxr-xr-x 2 root root 4096 Jan 14 20:59 gm-restore_2015-01-14_20-59-11

which system user postgres cannot even read …

        address@hidden:~/gnumed# su - postgres
        address@hidden:~$ ls -al /root/gnumed/gm-restore_2015-01-14_20-59-11/
        ls: cannot access /root/gnumed/gm-restore_2015-01-14_20-59-11/: 
Permission denied
        address@hidden:~$

??

-- Jim