[GH-ISSUE #87] Use postgresql database #45

New issue

Closed

opened 2026-03-03 01:24:07 +03:00 by kerem · 5 comments

kerem commented

2026-03-03 01:24:07 +03:00

Owner

Originally created by @rzig on GitHub (Jul 15, 2018).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/87

Hi! Would it be possible to add support for PostgreSQL? I'd like to use a database independent of the docker container.

Originally created by @rzig on GitHub (Jul 15, 2018). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/87 Hi! Would it be possible to add support for PostgreSQL? I'd like to use a database independent of the docker container.

kerem

2026-03-03 01:24:07 +03:00

closed this issue
added the
enhancement

low priority
labels

kerem commented

2026-03-03 01:24:08 +03:00

Author

Owner

@mprasil commented on GitHub (Jul 15, 2018):

It's definitely possible - diesel that's used as ORM layer does support Postgres, however it's not an easy task to do that. Having DB backed swap-able in place is not goal of diesel and hence you need some work around this.

Having said that I don't think we use SQL directly outside of the migrations code, so if someone is motivated enough to dive into the code to do that, patches would be welcome.

@mprasil commented on GitHub (Jul 15, 2018): It's definitely possible - diesel that's used as ORM layer does support Postgres, however it's not an easy task to do that. Having DB backed swap-able in place is not [goal of diesel](https://github.com/diesel-rs/diesel/issues/980#issuecomment-312849513) and hence you need some work around this. Having said that I don't think we use SQL directly outside of the migrations code, so if someone is motivated enough to dive into the code to do that, patches would be welcome.

kerem commented

2026-03-03 01:24:08 +03:00

Author

Owner

@mprasil commented on GitHub (Aug 10, 2018):

Note that we're using replace_into a lot. It appears, that this might not be supported with Postgres.

@mprasil commented on GitHub (Aug 10, 2018): Note that we're using [replace_into](https://docs.rs/diesel/1.2.2/diesel/fn.replace_into.html) a lot. It appears, that this might not be supported with Postgres.

kerem commented

2026-03-03 01:24:08 +03:00

Author

Owner

@jgrip commented on GitHub (Sep 27, 2018):

Upserts were added in 9.5, so this is supported on version 9.5 and up.
http://www.postgresqltutorial.com/postgresql-upsert/

Not looked at the bw_rs code to see how much work it would be yet.

@jgrip commented on GitHub (Sep 27, 2018): Upserts were added in 9.5, so this is supported on version 9.5 and up. http://www.postgresqltutorial.com/postgresql-upsert/ Not looked at the bw_rs code to see how much work it would be yet.

kerem commented

2026-03-03 01:24:08 +03:00

Author

Owner

@odarriba commented on GitHub (Nov 4, 2018):

It would be very helpful tonbe able to deploy bw_rs in Kubernetes and ease the backup of the files! Also running multiple nodes without direct file sharing

@odarriba commented on GitHub (Nov 4, 2018): It would be very helpful tonbe able to deploy bw_rs in Kubernetes and ease the backup of the files! Also running multiple nodes without direct file sharing

kerem commented

2026-03-03 01:24:08 +03:00

Author

Owner

@dani-garcia commented on GitHub (Nov 9, 2018):

To keep the issue tracker more focused, I'm closing this issue in favor of the meta issue at #246.

@dani-garcia commented on GitHub (Nov 9, 2018): To keep the issue tracker more focused, I'm closing this issue in favor of the meta issue at #246.