Restore DB from an old Djigzo installation fails partially

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

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.

Twitter: http://twitter.com/CipherMail