[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Health] GNU Health Database Copying
From: |
Luis Falcon |
Subject: |
Re: [Health] GNU Health Database Copying |
Date: |
Mon, 20 Feb 2012 15:33:05 -0300 |
Hey Chris
On Mon, Feb 20, 2012 at 1:33 PM, Christoph H. Larsen
<address@hidden> wrote:
> Dear All,
>
> I have some weird problems when trying to copy the data from my existing
> pilot_database to the production_database. Hey, copying a database is
> not magic, just a matter of:
> dump the pilot_database,
> createdb -O tryton -E utf8 production_database,
> psql production_database < ./pilot_database_dump
>
> But no! All I get out of this is the bare-bone Administration menu
> entry. Restoring the pilot_database to itself works, though.
>
> So, I thought, let's do:
>
> dump the pilot_database,
> createdb -O tryton -E utf8 -T pilot_database production_database,
> psql production_database < ./pilot_database_dump
>
> No fun, either. This is weird. Any ideas?
>
> Thanks a lot!
>
> Chris
>
I do it this way. It works just fine
Backup :
$ pg_dump gnuhealthdb > health_dump.sql
DB Creation and restore to a new db name
$createdb newdb
$psql newdb < health_dump.sql
Best
--
Luis Falcon
GNU Health
http://health.gnu.org