# Restore DJIGZo Backup to Ciphermail

**URL:** <https://community.ciphermail.com/t/restore-djigzo-backup-to-ciphermail/540>\
**Category:** Gateway\
**Created:** [April 14, 2017, 5:30pm UTC](https://community.ciphermail.com/t/restore-djigzo-backup-to-ciphermail/540 "2017-04-14T17:30:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Heater\_B\_Roger](https://avatars.discourse-cdn.com/v4/letter/h/c77e96/32.png) [@Heater\_B\_Roger](https://community.ciphermail.com/u/Heater_B_Roger)\
**Post date:** [April 14, 2017, 5:30pm UTC](https://community.ciphermail.com/t/restore-djigzo-backup-to-ciphermail/540/1 "2017-04-14T17:30:13Z")

</div>

We are moving from the DJIGZO appliance to the Ciphermail download instead of the appliance. We used sudo /usr/share/djigzo/scripts/backup.sh -b \> backup.tar to backup DJIGZO. But could not restore in Ciphermail using the menus. We found a script in Cipermail that looks like it restores backups but got a lot of errors. ./backup.sh -r -f /home/h2root/backup.tar -t postgres

It appears the data is in Ciphermail. Some of the errors are:

gzip: /home/h2root/backup.tar: not in gzip format  
tar: /etc/postfix/client-blacklist: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/postfix/client-blacklist.db: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/postfix/client-whitelist: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/postfix/client-whitelist.db: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/postfix/virtual-aliases: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/postfix/virtual-aliases.db: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/postfix/header-checks: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/postfix/transports: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/postfix/transports.db: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/aliases: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/aliases.db: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /usr/share/djigzo/resources/fonts/\*.ttf: Not found in archive  
tar: Exiting with failure status due to previous errors  
tar: /etc/djigzo/ip-filter.properties: Not found in archive  
tar: Exiting with failure status due to previous errors  
ERROR: constraint "fk31eb4613a92db044" of relation "admin\_authority" does not exist  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
ALTER TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP TABLE  
DROP SEQUENCE  
SET  
SET  
SET  
SET  
SET  
SET  
SET  
SET  
SET  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE TABLE  
ALTER TABLE  
CREATE SEQUENCE  
ALTER TABLE  
setval

![image001.png](https://europe1.discourse-cdn.com/flex017/uploads/ciphermail/original/1X/770ec3d84ec1c6b392dfb2f6a03bb8875252fde0.png)

> **···**
>
> --------  
> &nbsp;&nbsp;37524  
> (1 row)
> 
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> CREATE TABLE  
> ALTER TABLE  
> COPY 2  
> COPY 4  
> COPY 14  
> COPY 1  
> COPY 0  
> COPY 1385  
> COPY 1215  
> COPY 59  
> COPY 26  
> COPY 52  
> COPY 125  
> COPY 0  
> COPY 0  
> COPY 1  
> COPY 0  
> COPY 133  
> COPY 126  
> COPY 0  
> COPY 133  
> COPY 0  
> COPY 254  
> COPY 0  
> COPY 0  
> COPY 122  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> CREATE INDEX  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> REVOKE  
> REVOKE  
> GRANT  
> GRANT  
> ERROR: relation "admin" already exists  
> ERROR: relation "admin\_authority" already exists  
> ERROR: relation "authority" already exists  
> ERROR: relation "blob" already exists  
> ERROR: relation "certificaterequest" already exists  
> ERROR: relation "certificates" already exists  
> ERROR: relation "certificates\_email" already exists  
> ERROR: relation "crls" already exists  
> ERROR: relation "ctl" already exists  
> ERROR: relation "ctl\_namevalues" already exists  
> CREATE TABLE  
> CREATE TABLE  
> CREATE TABLE  
> ERROR: relation "keystore" already exists  
> ERROR: relation "mail\_repository" already exists  
> ERROR: relation "mail\_repository\_recipients" already exists  
> ERROR: relation "named\_blob" already exists  
> ERROR: relation "named\_blob\_named\_blob" already exists  
> CREATE TABLE  
> CREATE TABLE  
> ERROR: relation "properties" already exists  
> ERROR: relation "properties\_namevalues" already exists  
> ERROR: relation "sms" already exists  
> ERROR: relation "userpreferences" already exists  
> ERROR: relation "userpreferences\_certificates" already exists  
> ERROR: relation "userpreferences\_inheritedpreferences" already exists  
> ERROR: relation "userpreferences\_named\_blob" already exists  
> ERROR: relation "userpreferences\_named\_certificates" already exists  
> ERROR: relation "users" already exists  
> ERROR: constraint "fk31eb4613a92db044" for relation "admin\_authority" already exists  
> ERROR: constraint "fk31eb46135dd88a6" for relation "admin\_authority" already exists  
> ERROR: relation "certificaterequest\_email\_index" already exists  
> ERROR: relation "certificaterequest\_next\_update\_index" already exists  
> ERROR: relation "certificaterequest\_created\_index" already exists  
> ERROR: relation "certificates\_issuer\_index" already exists  
> ERROR: relation "certificates\_key\_alias\_index" already exists  
> ERROR: relation "certificates\_thumbprint\_index" already exists  
> ERROR: relation "certificates\_creationdate\_index" already exists  
> ERROR: relation "certificates\_subject\_index" already exists  
> ERROR: relation "certificates\_store\_name\_index" already exists  
> ERROR: relation "certificates\_subject\_key\_id\_index" already exists  
> ERROR: relation "certificates\_serial\_index" already exists  
> ERROR: constraint "fk904263596f91dc04" for relation "certificates\_email" already exists  
> ERROR: relation "crls\_thumbprint\_index" already exists  
> ERROR: relation "crls\_issuer\_index" already exists  
> ERROR: relation "crls\_crlnumber\_index" already exists  
> ERROR: relation "crls\_store\_name\_index" already exists  
> ERROR: constraint "fkc370b4312c4f7350" for relation "ctl\_namevalues" already exists  
> ALTER TABLE  
> ALTER TABLE  
> ALTER TABLE  
> ERROR: relation "keystore\_alias\_index" already exists  
> ERROR: relation "keystore\_storename\_index" already exists  
> ERROR: constraint "fk9f4a42d2a7662f3" for relation "mail\_repository" already exists  
> ERROR: constraint "fk16fd4d076bba8de5" for relation "mail\_repository\_recipients" already exists  
> ERROR: constraint "fkef3face33f4fe1e7" for relation "named\_blob" already exists  
> ERROR: constraint "fkc12079bf50dff003" for relation "named\_blob\_named\_blob" already exists  
> ERROR: constraint "fkc12079bf9df0d9c9" for relation "named\_blob\_named\_blob" already exists  
> ALTER TABLE  
> ERROR: constraint "fk1de74a19d9423b4c" for relation "properties\_namevalues" already exists  
> ERROR: relation "sms\_datelasttry\_index" already exists  
> ERROR: relation "userpreferences\_name\_index" already exists  
> ERROR: relation "userpreferences\_category\_index" already exists  
> ERROR: constraint "fk8551364dfe700867" for relation "userpreferences" already exists  
> ERROR: constraint "fk8551364d3f326a0d" for relation "userpreferences" already exists  
> ERROR: constraint "fkb8b48a6e4e408931" for relation "userpreferences\_certificates" already exists  
> ERROR: constraint "fkb8b48a6e6f91dc04" for relation "userpreferences\_certificates" already exists  
> ERROR: constraint "fk46abee904e408931" for relation "userpreferences\_inheritedpreferences" already exists  
> ERROR: constraint "fk46abee90f11d70ab" for relation "userpreferences\_inheritedpreferences" already exists  
> ERROR: constraint "fka77dca154e408931" for relation "userpreferences\_named\_blob" already exists  
> ERROR: constraint "fka77dca159df0d9c9" for relation "userpreferences\_named\_blob" already exists  
> ERROR: constraint "fkaab29434a3567c25" for relation "userpreferences\_named\_certificates" already exists  
> ERROR: constraint "fkaab294344e408931" for relation "userpreferences\_named\_certificates" already exists  
> ERROR: constraint "fk6a68e08ba1f7c2e" for relation "users" already exists  
> ERROR: relation "hibernate\_sequence" already exists  
> ERROR: relation "certificates\_email\_email\_index" already exists
> 
> Can you direct us as to if the above was successful or if there is a better process?  
> [cid:image001.png(a)01D2B522.7C8C7120]\<[Business & Corporate Lawyers | Howard & Howard](http://www.howardandhoward.com/&gt);  
> NOTICE: Information contained in this transmission to the named addressee is proprietary information and is subject to attorney-client privilege and work product confidentiality. If the recipient of this transmission is not the named addressee, the recipient should immediately notify the sender and destroy the information transmitted without making any copy or distribution thereof.
> 
> ELECTRONIC SIGNATURE: Nothing contained in this communication is intended to constitute an electronic signature unless a specific statement to the contrary is included in this message.

---

<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:** [April 17, 2017, 2:18pm UTC](https://community.ciphermail.com/t/restore-djigzo-backup-to-ciphermail/540/2 "2017-04-17T14:18:22Z")

</div>

Hi,

Most error/warning are just warning messages and can be ignored. For  
example "/etc/postfix/client-blacklist: Not found in archive" is only a  
warning that this file is not available in the backup tar.

The "relation "keystore" already exists" and other similar error  
messages are given because the tables/relations etc. already exist. The  
reason the DB creation script is run after import is to make sure that  
any database changes required by the new system are applied (the  
imported backup might not contain certain tables because the import if  
from an older version).

The only error message which is unexpected is the first error:

ERROR: constraint "fk31eb4613a92db044" of relation "admin\_authority"  
does not exist

not sure why that constraint did not exist (perhaps it was deleted in  
the previous import attempt?). However since the error is from the drop  
tables script and the constraint was added during import I think you can  
safely ignore this error.

Kind regards,

Martijn Brinkers

> **···**
>
> On 04/14/2017 07:30 PM, Heater, B. Roger wrote:
> 
> > We are moving from the DJIGZO appliance to the Ciphermail download instead of the appliance. We used sudo /usr/share/djigzo/scripts/backup.sh -b \> backup.tar to backup DJIGZO. But could not restore in Ciphermail using the menus. We found a script in Cipermail that looks like it restores backups but got a lot of errors. ./backup.sh -r -f /home/h2root/backup.tar -t postgres
> > 
> > It appears the data is in Ciphermail. Some of the errors are:
> > 
> > gzip: /home/h2root/backup.tar: not in gzip format  
> > tar: /etc/postfix/client-blacklist: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/postfix/client-blacklist.db: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/postfix/client-whitelist: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/postfix/client-whitelist.db: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/postfix/virtual-aliases: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/postfix/virtual-aliases.db: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/postfix/header-checks: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/postfix/transports: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/postfix/transports.db: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/aliases: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/aliases.db: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /usr/share/djigzo/resources/fonts/\*.ttf: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > tar: /etc/djigzo/ip-filter.properties: Not found in archive  
> > tar: Exiting with failure status due to previous errors  
> > ERROR: constraint "fk31eb4613a92db044" of relation "admin\_authority" does not exist  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP TABLE  
> > DROP SEQUENCE  
> > SET  
> > SET  
> > SET  
> > SET  
> > SET  
> > SET  
> > SET  
> > SET  
> > SET  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE SEQUENCE  
> > ALTER TABLE  
> > setval  
> > --------  
> > &nbsp;&nbsp;37524  
> > (1 row)
> > 
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > CREATE TABLE  
> > ALTER TABLE  
> > COPY 2  
> > COPY 4  
> > COPY 14  
> > COPY 1  
> > COPY 0  
> > COPY 1385  
> > COPY 1215  
> > COPY 59  
> > COPY 26  
> > COPY 52  
> > COPY 125  
> > COPY 0  
> > COPY 0  
> > COPY 1  
> > COPY 0  
> > COPY 133  
> > COPY 126  
> > COPY 0  
> > COPY 133  
> > COPY 0  
> > COPY 254  
> > COPY 0  
> > COPY 0  
> > COPY 122  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > CREATE INDEX  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > REVOKE  
> > REVOKE  
> > GRANT  
> > GRANT  
> > ERROR: relation "admin" already exists  
> > ERROR: relation "admin\_authority" already exists  
> > ERROR: relation "authority" already exists  
> > ERROR: relation "blob" already exists  
> > ERROR: relation "certificaterequest" already exists  
> > ERROR: relation "certificates" already exists  
> > ERROR: relation "certificates\_email" already exists  
> > ERROR: relation "crls" already exists  
> > ERROR: relation "ctl" already exists  
> > ERROR: relation "ctl\_namevalues" already exists  
> > CREATE TABLE  
> > CREATE TABLE  
> > CREATE TABLE  
> > ERROR: relation "keystore" already exists  
> > ERROR: relation "mail\_repository" already exists  
> > ERROR: relation "mail\_repository\_recipients" already exists  
> > ERROR: relation "named\_blob" already exists  
> > ERROR: relation "named\_blob\_named\_blob" already exists  
> > CREATE TABLE  
> > CREATE TABLE  
> > ERROR: relation "properties" already exists  
> > ERROR: relation "properties\_namevalues" already exists  
> > ERROR: relation "sms" already exists  
> > ERROR: relation "userpreferences" already exists  
> > ERROR: relation "userpreferences\_certificates" already exists  
> > ERROR: relation "userpreferences\_inheritedpreferences" already exists  
> > ERROR: relation "userpreferences\_named\_blob" already exists  
> > ERROR: relation "userpreferences\_named\_certificates" already exists  
> > ERROR: relation "users" already exists  
> > ERROR: constraint "fk31eb4613a92db044" for relation "admin\_authority" already exists  
> > ERROR: constraint "fk31eb46135dd88a6" for relation "admin\_authority" already exists  
> > ERROR: relation "certificaterequest\_email\_index" already exists  
> > ERROR: relation "certificaterequest\_next\_update\_index" already exists  
> > ERROR: relation "certificaterequest\_created\_index" already exists  
> > ERROR: relation "certificates\_issuer\_index" already exists  
> > ERROR: relation "certificates\_key\_alias\_index" already exists  
> > ERROR: relation "certificates\_thumbprint\_index" already exists  
> > ERROR: relation "certificates\_creationdate\_index" already exists  
> > ERROR: relation "certificates\_subject\_index" already exists  
> > ERROR: relation "certificates\_store\_name\_index" already exists  
> > ERROR: relation "certificates\_subject\_key\_id\_index" already exists  
> > ERROR: relation "certificates\_serial\_index" already exists  
> > ERROR: constraint "fk904263596f91dc04" for relation "certificates\_email" already exists  
> > ERROR: relation "crls\_thumbprint\_index" already exists  
> > ERROR: relation "crls\_issuer\_index" already exists  
> > ERROR: relation "crls\_crlnumber\_index" already exists  
> > ERROR: relation "crls\_store\_name\_index" already exists  
> > ERROR: constraint "fkc370b4312c4f7350" for relation "ctl\_namevalues" already exists  
> > ALTER TABLE  
> > ALTER TABLE  
> > ALTER TABLE  
> > ERROR: relation "keystore\_alias\_index" already exists  
> > ERROR: relation "keystore\_storename\_index" already exists  
> > ERROR: constraint "fk9f4a42d2a7662f3" for relation "mail\_repository" already exists  
> > ERROR: constraint "fk16fd4d076bba8de5" for relation "mail\_repository\_recipients" already exists  
> > ERROR: constraint "fkef3face33f4fe1e7" for relation "named\_blob" already exists  
> > ERROR: constraint "fkc12079bf50dff003" for relation "named\_blob\_named\_blob" already exists  
> > ERROR: constraint "fkc12079bf9df0d9c9" for relation "named\_blob\_named\_blob" already exists  
> > ALTER TABLE  
> > ERROR: constraint "fk1de74a19d9423b4c" for relation "properties\_namevalues" already exists  
> > ERROR: relation "sms\_datelasttry\_index" already exists  
> > ERROR: relation "userpreferences\_name\_index" already exists  
> > ERROR: relation "userpreferences\_category\_index" already exists  
> > ERROR: constraint "fk8551364dfe700867" for relation "userpreferences" already exists  
> > ERROR: constraint "fk8551364d3f326a0d" for relation "userpreferences" already exists  
> > ERROR: constraint "fkb8b48a6e4e408931" for relation "userpreferences\_certificates" already exists  
> > ERROR: constraint "fkb8b48a6e6f91dc04" for relation "userpreferences\_certificates" already exists  
> > ERROR: constraint "fk46abee904e408931" for relation "userpreferences\_inheritedpreferences" already exists  
> > ERROR: constraint "fk46abee90f11d70ab" for relation "userpreferences\_inheritedpreferences" already exists  
> > ERROR: constraint "fka77dca154e408931" for relation "userpreferences\_named\_blob" already exists  
> > ERROR: constraint "fka77dca159df0d9c9" for relation "userpreferences\_named\_blob" already exists  
> > ERROR: constraint "fkaab29434a3567c25" for relation "userpreferences\_named\_certificates" already exists  
> > ERROR: constraint "fkaab294344e408931" for relation "userpreferences\_named\_certificates" already exists  
> > ERROR: constraint "fk6a68e08ba1f7c2e" for relation "users" already exists  
> > ERROR: relation "hibernate\_sequence" already exists  
> > ERROR: relation "certificates\_email\_email\_index" already exists
> > 
> > Can you direct us as to if the above was successful or if there is a better process?  
> > [cid:image001.png(a)01D2B522.7C8C7120]\<[Business & Corporate Lawyers | Howard & Howard](http://www.howardandhoward.com/&gt);  
> > NOTICE: Information contained in this transmission to the named addressee is proprietary information and is subject to attorney-client privilege and work product confidentiality. If the recipient of this transmission is not the named addressee, the recipient should immediately notify the sender and destroy the information transmitted without making any copy or distribution thereof.
> > 
> > ELECTRONIC SIGNATURE: Nothing contained in this communication is intended to constitute an electronic signature unless a specific statement to the contrary is included in this message.
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)
> 
> --  
> 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)
