# Restore DB from an old Djigzo installation fails partially

**URL:** <https://community.ciphermail.com/t/restore-db-from-an-old-djigzo-installation-fails-partially/577>\
**Category:** Gateway\
**Created:** [November 6, 2017, 8:56pm UTC](https://community.ciphermail.com/t/restore-db-from-an-old-djigzo-installation-fails-partially/577 "2017-11-06T20:56:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stefan\_Gunther](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@Stefan\_Gunther](https://community.ciphermail.com/u/Stefan_Gunther)\
**Post date:** [November 6, 2017, 8:56pm UTC](https://community.ciphermail.com/t/restore-db-from-an-old-djigzo-installation-fails-partially/577/1 "2017-11-06T20:56:13Z")

</div>

Good evening,

one of our clients decided to only use pg\_dump to backup his Djigzo Installation, which was probably about 6 years old.

During the last weekend the single(!) hard disk gave up.

A restore of the database produced a number of error messages which seemed to be related to the postgresql db itself.

The current status of the ciphermail installation is, that all certificates were imported, but the aren't any users.

Has this been caused by a change in the structure of the database?

Shall we try to install an old 2.x djigzo, import the database and than perform a regular backup via the webinterface?

Thanks for any suggestions.

Best regards,

Stefan

---

<div class="post-metadata">

**Author:** ![martijn](https://dub1.discourse-cdn.com/flex017/user_avatar/community.ciphermail.com/martijn/32/127_2.png) [@martijn](https://community.ciphermail.com/u/martijn)\
**Post date:** [November 7, 2017, 7:48am UTC](https://community.ciphermail.com/t/restore-db-from-an-old-djigzo-installation-fails-partially/577/2 "2017-11-07T07:48:20Z")

</div>

> Good evening,
> 
> one of our clients decided to only use pg\_dump to backup his Djigzo Installation, which was probably about 6 years old.
> 
> During the last weekend the single(!) hard disk gave up.
> 
> A restore of the database produced a number of error messages which seemed to be related to the postgresql db itself.

What error messages are produced?

> The current status of the ciphermail installation is, that all certificates were imported, but the aren't any users.
> 
> Has this been caused by a change in the structure of the database?
> 
> Shall we try to install an old 2.x djigzo, import the database and than perform a regular backup via the webinterface?

The database changes between versions were minimal. Only tables were  
added but not modified.

Is the SQL dump in binary format or text format? If in binary format it  
could be that the binary format is not compatible with a newer  
PostgreSQL release. One option in that case would be to import the dump  
into an older version of PostgreSQL and then dump in text format.

Kind regards,

Martijn

> **···**
>
> On 06-11-17 21:56, Stefan Michael Guenther via Users wrote:
> 
> --  
> CipherMail email encryption
> 
> Email encryption with support for S/MIME, OpenPGP, PDF encryption and  
> secure webmail pull.
> 
> > **[CipherMail email encryption and digital signatures](https://www.ciphermail.com)**
> >
> > Easy to use server-side email encryption for automatic encryption and digital signing of email.
> 
> Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)