[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Health] issue while trying to duplicate an existing gnuhealth/Tryto
From: |
Axel Braun |
Subject: |
Re: [Health] issue while trying to duplicate an existing gnuhealth/Tryton database |
Date: |
Wed, 24 Aug 2016 14:03:01 +0200 |
User-agent: |
KMail/4.14.10 (Linux/4.1.27-27-default; KDE/4.14.18; x86_64; ; ) |
Hi Armand,
Am Mittwoch, 24. August 2016, 10:19:31 schrieb Armand MPASSY-NZOUMBA:
> Dear community,
> I need your assistance with the duplicating of an existing database under
> gnuhealth 3.01.I proceeded as follows:
>
> As gnu health user
> Step 1: Backup your database$ pg_dump -C health30 > health30.sql
looks good....
> Step 2: Create an empty database to import the backup database into$
> createdb --encoding=unicode health30_v2
Maybe you should set the user of the DB?
createdb health30_v2 --encoding='UTF8' –owner=gnuhealth
> Step 3: Import the database into
> the newly created database$ psql health30_v2 < health30.sql
> I get errors and an empty database health30_v2
What errors?
Cheers
Axel