Postgres

Deploying the Postgres database is beyond the scope of this guide. An existing Postgres database can be used, or a new one can be deployed. If using an existing database shared with other modules, ensure a new schema is created for the PTMGR module to avoid name collisions.

Schema Initializing

SQL script to initialize the schema can be found inside the directory of the released source code.

app/schema
└── postgres
    ├── schema.sql
    └── version.go

To initialize the schema, run the script using preferred SQL client or use the psql command below, assuming the command is executed within a postgres container.

psql -U USERNAME -d PASSWORD -f /app/schema/schema.sql

• Replace USERNAME with your postgres username
• Replace PASSWORD with your postgres password