How to open/use the pgc file (database dump)

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

1. Open the downloaded "7z" file, inside you will find <customer>prod.pgc: extract this file from the archive

2. Download an install PostgreSQL from: http://www.postgresql.org/ using the instructions in the installer

3. Part of the Windows installation is PGAdmin, start this tool

4. Connect to the database, right click on "database" and choose "New Database",
   * name: <customer>prod
   * encoding: UTF8

5. Once finished, right click <customer>prod and choose "Restore database"

6. 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