Re: [Gnumed-devel] A problem (again) with backing up on Mac

[Busser, Jim]

On 2014-01-29, at 3:18 PM, Jim Busser <address@hidden> wrote:

> I think I am again running into problems with permissions on Mac, in spite of 
> having believed I had previously made adequate notes.
> 
> ===============================================
> 
> macbook:gnumed djb$ sh gm-backup_database.sh
> Password: 
> Backing up database gnumed_v18.
> 
> However, a newer database seems to exist:
> 
> Password: 
> gnumed_v18 | gm-dbo   | UTF8     | en_CA       | en_CA       | 
> gnumed_v19 | gm-dbo   | UTF8     | en_CA       | en_CA       | 
> 
> Make sure you really want to backup the older database !
> tar: 
> backup-gnumed_v18-GNUmed_Team-macbook.vch.ca-2014-01-29-14-54-27-database.sql:
>  Cannot stat: No such file or directory
> tar: Error exit delayed from previous errors.
> Creating backup tar archive 
> [backup-gnumed_v18-GNUmed_Team-macbook.vch.ca-2014-01-29-14-54-27.tar] 
> failed. Aborting.

Sheesh! Not a permissions problem.

It was case of tar naturally failing, because pg_dump had failed, consequently 
there existed no dump to tar.

The clue was when I tried pg_dump directly from the command line:

        macbook:gnumed djb$ pg_dump -U gm-dbo --data-only -f test.sql gnumed_v19
        pg_dump: server version: 9.3.1; pg_dump version: 8.4.9
        pg_dump: aborting because of server version mismatch

fixed by

        PATH=/Library/PostgreSQL/9.3/bin:$PATH

!!

-- Jim

signature.asc
Description: Message signed with OpenPGP using GPGMail