PostgreSQL backend?

[beeing]

Hi @stremovsky, thank you for such as great project. It definitely helps many developers on PII compliance.

Just wondering is there a plan to support alternate DB like PostgreSQL? It is easier for self-hosting since there's existing tech stacks for this.

Thanks in advance!

[stremovsky]

Hello

I do support PostgreSQL in the Databunker PRO. It is used for multi- tenancy implemented using PostgreSQL row-based security feature.

If the community wants PostgreSQL support I can port the code to the regular version of Databunker.

Best regards, Yuli

[stremovsky]

I committed the postgresql support: https://github.com/securitybunker/databunker/blob/master/src/storage/pgsql-storage.go

I will need to do some tests to make sure it is working.

[stremovsky]

You will be able now to run Databunker with PostgreSQL

First run: ./generate-pgsql-env-files.sh script to generate .env directory and files with sectets.

Run docker-compose -f docker-compose-pgsql.yml up to start postgresql container and databunker together.

Best of luck!

[beeing]

Thanks @stremovsky, let me try it out and report if there's any issues.

[rakateja]

hey @beeing, have you tried Databunker with PostgreSQL in production? how was it? Thank you 🙇

[stremovsky]

@rakateja I am running it for quite a long time and I see no problems.

Thanks