Re: [Health] GNU Health Database Copying

[Luis Falcon]

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