Introduction
Previously, you downloaded a database dump from the Carerix site. Now you want to "open" this dump file.
Requirements
- Version of PostgreSQL should support restoring a PostgreSQL version 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 an install PostgreSQL from: http://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: UTF8 - Once finished, right click <customer>prod and choose "Restore database"
- Browse to the pgc file you uncompressed 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 data. (i.e. all attachments appear to have length 0)
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.
____
Keywords: UD-2079