# PostgreSQL configuration for InsForge
# Enable logical replication for Logflare

# Listen on all interfaces to allow container connections
listen_addresses = '*'

# Set WAL level to logical for Logflare replication
wal_level = logical

# Set max replication slots (needed for logical replication)
max_replication_slots = 10

# Set max WAL senders
max_wal_senders = 10

# Shared preload libraries
shared_preload_libraries = 'pg_cron,http,pgcrypto,insforge_pg_utils'

insforge.policy_grant_role = 'project_admin'
insforge.policy_grant_tables = 'storage.objects,realtime.channels,realtime.messages,payments.stripe_checkout_sessions,payments.stripe_customer_portal_sessions,payments.razorpay_orders,payments.razorpay_subscriptions'

# InsForge-internal schemas that must never be exposed to the REST data API.
# Read by system.is_exposed_schema (migration 056) to decide PostgREST's
# db_schemas allowlist. Comma-separated, no spaces. Postgres internals (pg_*,
# information_schema) and extension-owned schemas are handled separately and
# need not be listed here. Edit + `SELECT pg_reload_conf()` to apply at runtime.
insforge.internal_schemas = 'ai,auth,compute,deployments,email,functions,memory,payments,realtime,schedules,storage,system'

cron.database_name = 'insforge' # Add this line to specify the database for pg_cron