PostgreSQL — the relational engine powering 4softerp financial ERP
All financial data, contracts, invoices and multi-company balances in 4softerp are persisted in PostgreSQL — the open-source database with the strongest ACID support in the industry. Every transaction is atomic, every audit trail is complete.
Why PostgreSQL for a financial ERP
ACID guaranteed on financial transactions
Every accounting entry, payment or invoice goes through a complete PostgreSQL transaction. No intermediate states or data loss on reboot.
Multi-company isolation via Row-Level Security
Each tenant and each managed company is isolated at row level — a query cannot read another company's data, even in a shared database.
JSONB for variable fiscal-specific data
Optional fields (NACE codes, SAF-T parameters, item attributes) are stored in JSONB columns with GIN indexes, without forcing a rigid schema.
Native full-text search for documents
Search across item names, partners and transaction descriptions runs directly in PostgreSQL with ts_vector — no external search engine dependency.
Extensions: pg_partman + TimescaleDB
Journal and bank statement tables are partitioned by month via pg_partman; TimescaleDB accelerates time-series aggregations for monthly balance.
Streaming replication + PITR
Real-time streaming replication for read replicas; Point-in-Time Recovery allows restoring the database to any second in the last 30 days.
FAQ about PostgreSQL in 4softerp
Which PostgreSQL version does 4softerp use?
Version 16 LTS, with planned upgrade to 17 after stabilization. Migrations are managed through Alembic with incremental versioning.
Is financial data encrypted at rest?
Yes — PostgreSQL data volumes are encrypted at disk level (LUKS) on all production servers. Connections enforce TLS 1.3.
How often are backups taken?
Full daily backup and continuous WAL streaming, retained for 30 days. PITR guarantees RPO < 1 minute.
Can I export data from the database?
Yes — 4softerp offers XML/JSON export via authenticated API and CSV export directly from the dashboard. Data always belongs to the client.
Solid financial ERP, built on PostgreSQL
Try 4softerp free for 6 months and discover how relational architecture guarantees the integrity of your company's data.