Introduction
You previously downloaded a database dump from the Carerix site. Now you want to open this dump file.
Requirements
Your version of PostgreSQL should support restoring a PostgreSQL 9.4 dump
A database user "carerix" must be created first
Errors about "zettair" are about an optional external database module and can be safely ignored
Method
Open the downloaded "7z" file — inside you will find <customer>prod.pgc. Extract this file from the archive.
Download and install PostgreSQL from www.postgresql.org, using the instructions in the installer.
Part of the Windows installation is PGAdmin — start this tool.
Connect to the database, right-click on "database," and choose "New Database":
* name: <customer>prod
* encoding: UTF8Right-click <customer>prod and choose "Restore database."
Browse to the pgc file you extracted in step 1 and click OK. The database will now be restored. Any errors about gtsvector can be ignored.
Attachment data
The standard database dump does not include attachment content (all attachments will appear to have a length of 0 in this file).
Should you require the content of the attachments as well, you can order it from us. You will then receive an additional 7zip file which contains the attachments in compressed format. For more information, you can request an informational PDF from your account manager.