Re: [Health] issue while trying to duplicate an existing gnuhealth/Tryton database

[Luis Falcon]

Dear Armand 
On Fri, 26 Aug 2016 14:43:02 +0000 (UTC)
Armand MPASSY-NZOUMBA <address@hidden> wrote:

> Dear Luis,
> Muchas Gracias!The issue has been resolved. It was a little bit tricky
> 

Great !! Glad to know that you got it working :)
> 
> 
>    >On Thursday, August 25, 2016 3:25 PM, Luis Falcon
>    ><address@hidden> wrote:  
>  
> >You're trying to import a dump into an existing database (a database
> >that already has objects). That's the error that you are getting.  
> 
> >Make sure that you create a new database from scratch, and that you
> >import the dump to the newly created DB.  
> 
> >Try something like this, with your gnuhealth user:  
> 
> >$ pg_dump your_existing_db > your_db_backup.sqlIt works fine. I was
> >using the following command instead:  
> $ pg_dump -C your_existing_db > your_db_backup.sql
> This led to the issue I had.

Yes, don't use "-C" on pg_dump :)

Again, happy to know it's working now.

All the best
Luis