Does it support postgresql database backup?

Question

Does it support postgresql database backup?

Seele0oO opened this issue 2 years ago · 15 comments

Use this parameter.

DATABASE_URL: "postgresql://exampleuser:examplepasswd@db/postgres"

The vault can be stored to it. Using this approach you can create distributed vaultwarden.

So does this backup function support postgresql backup function?

Answer 1 · 2022-12-05T09:00:59.000Z

~/Documents/bitwarden/data ❯ tree                                                                                           12s 16:59:47
.
├── attachments
├── icon_cache
│   └── 1.cn.png.miss
├── rsa_key.pem
├── rsa_key.pub.pem
├── sends
└── tmp

At this point a password is stored in the database.

Answer 2 · 2022-12-06T14:09:09.000Z

@Seele0oO ,

I have researched and only need to modify a small amount of code to support PostgreSQL and MariaDB/MySQL .

But I'm not good with databases and don't know how to backup and restore PostgreSQL and MariaDB/MySQL data properly.

Another problem occurs in the restore phase, sqlite can be restored by just copying the db file to the folder, but other databases need to execute sql, this is also the aspect that bothers me.

If you can provide the shell command for PostgreSQL database backup and restore, I will finish the support for PostgreSQL as soon as possible. If you can also provide commands for MariaDB/MySQL, that would be great.

Answer 3 · 2022-12-07T02:33:56.000Z

Thank you for your attention,I have done some shell scripts, but I am not very skilled, so I wrote some example, hope it is useful for you.

Seele0oO@b9e1c24

Answer 4 · 2022-12-07T03:05:31.000Z

by the way,It's not a good idea to use mysql, I think it's too heavy.
There is some example.
Seele0oO@4227273

In my view,the MariaDB/MySQL is the same in commands.
So it's probably universal.

Answer 5 · 2022-12-11T15:34:19.000Z

@Seele0oO ,

The PostgreSQL backend is now supported, try it on 1.16.0-beta.0.

Please let me know if you have any questions.

I will continue to add MySQL/MariaDB support.

Answer 6 · 2022-12-11T15:41:44.000Z

thanks for your work.I will test it in few days later.Take care yourself and be well. It is the time to sleeping.

Answer 7 · 2022-12-17T09:24:05.000Z

1.16.0-beta.1 is support Mysql(MariaDB) and PostgreSQL backend.

Answer 8 · 2022-12-25T14:13:58.000Z

1.16.0-beta.2 is support PostgreSQL 15. And earlier beta versions are no longer available.

Answer 9 · 2022-12-26T11:12:54.000Z

I'm wondering if I'm missing some environment variables that specify the backup method? In my tests, the data in the datagrip-connected postgresql database changed as I made changes, but the backup program still just backed up those files.

After I added some attachments to my test account, these two folders remained empty.

Answer 10 · 2022-12-26T12:06:03.000Z

Please provide environment variables.

Answer 11 · 2022-12-27T01:56:32.000Z

vaultwarden:
  environment:
     SIGNUPS_ALLOWED: 'true'
     DATABASE_URL: 'postgresql://postgres:example@db/postgres'

backup:
    environment:
      CRON: '*/5 * * * *'

  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_PASSWORD: example

Answer 12 · 2022-12-27T03:03:10.000Z

Sorry, please check the document.

Answer 13 · 2023-01-29T01:10:52.000Z

@Seele0oO ,

Hello, is the postgresql database backup working?

Answer 14 · 2023-01-29T01:55:14.000Z

It works fine on Debain 11.
I can't test it with mysql because of the preformance of my password-server.

Answer 15 · 2023-01-29T13:56:24.000Z

Released stable version v1.16.0.