PostgreSQL database configuration

When using PostgreSQL, both your application's datastore and the K2BAudit datastore must connect to the same database. However, you can (and should) use a separate schema for K2BAudit—we recommend using a schema named 'k2baudit'.

Example

- Application tables: 'public' schema (or your existing schema)
- K2BAudit tables: 'k2baudit' schema

Why?

PostgreSQL does not support cross-database queries, so both datastores must use the same database. Using different schemas keeps audit data organized and separate from your application data.

Summary

- Use the same database for both datastores.
- Use different schemas (e.g., 'k2baudit' for audit data).