postgresql env template #565

Closed
opened 2026-02-04 21:34:19 +03:00 by OVERLORD · 4 comments
Owner

Originally created by @etibamecus on GitHub (Jan 16, 2020).

Hello,

I just compiled bitwarden_rs using postgresql.

now i'm setting my bitwarden_rs.env file and I don't really if i'm supposed to point to a database and if yes, what should i set in front of DATABASE_URL=

thanks a lot for all your work !

Originally created by @etibamecus on GitHub (Jan 16, 2020). Hello, I just compiled bitwarden_rs using postgresql. now i'm setting my bitwarden_rs.env file and I don't really if i'm supposed to point to a database and if yes, what should i set in front of DATABASE_URL= thanks a lot for all your work !
Author
Owner

@xoxys commented on GitHub (Jan 17, 2020):

Connection string should be something like DATABASE_URL=postgresql://localhost/test?user=fred&password=secret. You'll need a running postgres server and adjust the hostname and user/password values.

But I am working on my own bitwarden_rs + postgres setup currently and can say more in a couple of minutes.

@xoxys commented on GitHub (Jan 17, 2020): Connection string should be something like `DATABASE_URL=postgresql://localhost/test?user=fred&password=secret`. You'll need a running postgres server and adjust the hostname and user/password values. But I am working on my own bitwarden_rs + postgres setup currently and can say more in a couple of minutes.
Author
Owner

@etibamecus commented on GitHub (Jan 17, 2020):

nice !

so if using UNIX socket can it be DATABASE_URL=postgresql://unix:/var/run/postgresql/.s.PGSQL.5432/test?user=fred&password=secret ?

would you consider it stable yet to use postgresql ?

thanks again !

@etibamecus commented on GitHub (Jan 17, 2020): nice ! so if using UNIX socket can it be `DATABASE_URL=postgresql://unix:/var/run/postgresql/.s.PGSQL.5432/test?user=fred&password=secret` ? would you consider it stable yet to use postgresql ? thanks again !
Author
Owner

@xoxys commented on GitHub (Jan 20, 2020):

so if using UNIX socket can it be DATABASE_URL=postgresql://unix:/var/run/postgresql /.s.PGSQL.5432/test?user=fred&password=secret ?

Don't know if Unix socket will work, try it. For me the full Postgres URL schema works e.g.: BITWARDENRS_DATABASE_URL=postgresql://<USER>:<PASS>@<HOSTNAME>:<PORT>/<DBNAME>?sslmode=verify-full&sslrootcert=/etc/ssl/certs/ca-certificates.crt

would you consider it stable yet to use postgresql ?

I'm also just a user and not that deep in the code base. For me it works great for now.

@xoxys commented on GitHub (Jan 20, 2020): > so if using UNIX socket can it be `DATABASE_URL=postgresql://unix:/var/run/postgresql /.s.PGSQL.5432/test?user=fred&password=secret` ? Don't know if Unix socket will work, try it. For me the full Postgres URL schema works e.g.: `BITWARDENRS_DATABASE_URL=postgresql://<USER>:<PASS>@<HOSTNAME>:<PORT>/<DBNAME>?sslmode=verify-full&sslrootcert=/etc/ssl/certs/ca-certificates.crt` > would you consider it stable yet to use postgresql ? I'm also just a user and not that deep in the code base. For me it works great for now.
Author
Owner

@dani-garcia commented on GitHub (May 14, 2020):

Closed due to inactivity.

@dani-garcia commented on GitHub (May 14, 2020): Closed due to inactivity.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/vaultwarden#565