[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


Luis Falcon
GNU Health

reply via email to

[Prev in Thread] Current Thread [Next in Thread]