Get an empty database after performing a restore

Armand Mpassy-Nzoumba

unread,

Jun 29, 2016, 9:41:31 PM6/29/16

to Tryton List

Deal all,

I am failing to restore a database on trytond 3.8 (GNU Health version 3.0)

I used the following steps:

I did successfully backup the database using pg_dump

I did restore it on a newly created empty database test8 using the command:

psql test8 < dump_database

I the upgraded the database with tryton

/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.3/bin/trytond --config /home/gnuhealth/gnuhealth/tryton/server/config/trytond.conf --all -d test8

The server asks with the admin password for the test8 database

When I connect to the database with the tryton client, I found an empty database and the server ask me to initialise it.

I am sure I am missing something but I don’t know what?

May you assist?

Kind regards

Armand

Cédric Krier

unread,

Jun 30, 2016, 2:45:04 AM6/30/16

to Tryton List

On 2016-06-30 02:41, 'Armand Mpassy-Nzoumba' via tryton wrote:
> Deal all,
>
> I am failing to restore a database on trytond 3.8 (GNU Health version 3.0)
> I used the following steps:
>
> I did successfully backup the database using pg_dump
> I did restore it on a newly created empty database test8 using the command:
>
> psql test8 < dump_database

I guess your file "dump_database" is empty

> I the upgraded the database with tryton
>
> /home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.3/bin/trytond --config /home/gnuhealth/gnuhealth/tryton/server/config/trytond.conf --all -d test8
>
> The server asks with the admin password for the test8 database
>
> When I connect to the database with the tryton client, I found an empty database and the server ask me to initialise it.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

Armand Mpassy-Nzoumba

unread,

Jun 30, 2016, 6:03:31 AM6/30/16

to Tryton List

> On 30 Jun 2016, at 07:41, Cédric Krier <cedric...@b2ck.com> wrote:
>
> On 2016-06-30 02:41, 'Armand Mpassy-Nzoumba' via tryton wrote:
>> Deal all,
>>
>> I am failing to restore a database on trytond 3.8 (GNU Health version 3.0)
>> I used the following steps:
>>
>> I did successfully backup the database using pg_dump
>> I did restore it on a newly created empty database test8 using the command:
>>
>> psql test8 < dump_database
>
> I guess your file "dump_database" is empty

Yes it looks like it is.
I successfully managed to backup the database with the Tryton client. However restoring it using the client failed.
Thank you.
Armand

Sergi Almacellas Abellana

unread,

Jun 30, 2016, 6:33:21 AM6/30/16

to try...@googlegroups.com

El 30/06/16 a les 11:58, Armand Mpassy-Nzoumba ha escrit:

Take in account that this will be no longer available for future
versions [1]

So I will recommend you using pg_dump and psql to backup and restore
your databases)

[1] https://bugs.tryton.org/issue5384
--
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

Armand Mpassy-Nzoumba

unread,

Jun 30, 2016, 7:53:32 AM6/30/16

to Tryton List

> On 30 Jun 2016, at 11:33, Sergi Almacellas Abellana <se...@koolpi.com> wrote:
>
> Take in account that this will be no longer available for future versions [1]
>
> So I will recommend you using pg_dump and psql to backup and restore your databases)

Yes well noted.
Kind regards,

Armand

Reply all

Reply to author

Forward