vaultwarden 从 MySQL 迁移到 PostgreSQL
- PostgreSQL 更适合具有频繁写入操作和复杂查询的企业级应用程序。
- 如果您的应用程序需要频繁更新数据，则 PostgreSQL 是更好的选择。但是，如果您需要频繁读取数据，则首选 MySQL。
迁移数据库：mariadb 版本:11.4.2 -> postgresql 版本:16.3
请注意，使用此方法风险自负，并且强烈建议备份您的安装和数据！这 不受支持，也没有经过强有力的测试。
一、为 Vaultwarden 创建一个新的（空）数据库
CREATE DATABASE vaultwarden;
二、创建数据库用户 vaultwarden
- 并授予数据库权限
CREATE USER vaultwarden WITH ENCRYPTED PASSWORD 'yourpassword';
GRANT ALL ON SCHEMA public TO vaultwarden;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO vaultwarden;
三、配置并启动 Vaultwarden
以便 diesel 可以运行迁移并设置正确的模式。除此之外不要做别的。
docker compose up
- 不能有报错，默认是这个界面 👇
root@ubuntu:/docker/vaultwarden# docker compose logs -f
vaultwarden | /--------------------------------------------------------------------\
vaultwarden | | Starting Vaultwarden |
vaultwarden | | Version 1.33.2 |
vaultwarden | |--------------------------------------------------------------------|
vaultwarden | | This is an *unofficial* Bitwarden implementation, DO NOT use the |
vaultwarden | | official channels to report bugs/features, regardless of client. |
vaultwarden | | Send usage/configuration questions or feature requests to: |
vaultwarden | | https://github.com/dani-garcia/vaultwarden/discussions or |
vaultwarden | | https://vaultwarden.discourse.group/ |
vaultwarden | | Report suspected bugs/issues in the software itself at: |
vaultwarden | | https://github.com/dani-garcia/vaultwarden/issues/new |
vaultwarden | \--------------------------------------------------------------------/
vaultwarden |
vaultwarden | [INFO] Using saved config from `data/config.json` for configuration.
vaultwarden |
运行后会自动配置数据库条目，然后停止 Vaultwarden
- Ctrl + C 停止即可，或者使用
docker compose down
四、创建 vaultwarden.load 文件：
load database
from mysql://vaultwarden:[email protected]:3306/vaultwarden
into postgresql://vaultwarden:[email protected]:5432/vaultwarden
WITH data only
EXCLUDING TABLE NAMES MATCHING '__diesel_schema_migrations'
ALTER SCHEMA 'vaultwarden' RENAME TO 'public'
;
如果您的连接需要 SSL，可以选择将
?sslmode=require添加到 PostgreSQL 连接字符串中。
五、docker 运行 pgloader vaultwarden.load 命令
您可能会看到一些警告，（不用理会）迁移会成功完成。
docker run --rm -v "$(pwd)/vaultwarden.load:/pgloader/vaultwarden.load" dimitri/pgloader:latest pgloader /pgloader/vaultwarden.load
root@ubuntu:/docker/vaultwarden# docker run --rm -v "$(pwd)/vaultwarden.load:/pgloader/vaultwarden.load" dimitri/pgloader:latest pgloader /pgloader/vaultwarden.load
2025-03-30T15:38:53.025002Z LOG pgloader version "3.6.7~devel"
2025-03-30T15:38:53.207006Z LOG Migrating from #<MYSQL-CONNECTION mysql://[email protected]:3306/vaultwarden {1007E075E3}>
2025-03-30T15:38:53.207006Z LOG Migrating into #<PGSQL-CONNECTION pgsql://[email protected]:5432/vaultwarden {1007E08393}>
2025-03-30T15:38:54.083025Z WARNING Source column "public"."attachments"."id" is casted to type "char" which is not the same as "text", the type of current target database column "public"."attachments"."id".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."attachments"."cipher_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."attachments"."cipher_uuid".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."auth_requests"."device_type" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."auth_requests"."device_type".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."auth_requests"."creation_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."auth_requests"."creation_date".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."auth_requests"."response_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."auth_requests"."response_date".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."auth_requests"."authentication_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."auth_requests"."authentication_date".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers"."uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."ciphers"."uuid".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers"."created_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."ciphers"."created_at".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers"."updated_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."ciphers"."updated_at".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers"."user_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."ciphers"."user_uuid".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers"."organization_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."ciphers"."organization_uuid".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers"."atype" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ciphers"."atype".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers"."deleted_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."ciphers"."deleted_at".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers"."reprompt" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."ciphers"."reprompt".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers_collections"."cipher_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."ciphers_collections"."cipher_uuid".
2025-03-30T15:38:54.083025Z WARNING Source column "public"."ciphers_collections"."collection_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."ciphers_collections"."collection_uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."devices"."uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."devices"."uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."devices"."created_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."devices"."created_at".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."devices"."updated_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."devices"."updated_at".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."devices"."user_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."devices"."user_uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."devices"."atype" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."devices"."atype".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."emergency_access"."atype" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."emergency_access"."atype".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."emergency_access"."status" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."emergency_access"."status".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."emergency_access"."wait_time_days" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."emergency_access"."wait_time_days".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."emergency_access"."recovery_initiated_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."emergency_access"."recovery_initiated_at".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."emergency_access"."last_notification_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."emergency_access"."last_notification_at".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."emergency_access"."updated_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."emergency_access"."updated_at".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."emergency_access"."created_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."emergency_access"."created_at".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."event"."event_type" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."event"."event_type".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."event"."device_type" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."event"."device_type".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."event"."event_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."event"."event_date".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."favorites"."user_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."favorites"."user_uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."favorites"."cipher_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."favorites"."cipher_uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."folders"."uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."folders"."uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."folders"."created_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."folders"."created_at".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."folders"."updated_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."folders"."updated_at".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."folders"."user_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."folders"."user_uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."folders_ciphers"."cipher_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."folders_ciphers"."cipher_uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."folders_ciphers"."folder_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."folders_ciphers"."folder_uuid".
2025-03-30T15:38:54.084025Z WARNING Source column "public"."groups"."creation_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."groups"."creation_date".
2025-03-30T15:38:54.086025Z WARNING Source column "public"."groups"."revision_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."groups"."revision_date".
2025-03-30T15:38:54.087025Z WARNING Source column "public"."invitations"."email" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."invitations"."email".
2025-03-30T15:38:54.087025Z WARNING Source column "public"."organization_api_key"."atype" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."organization_api_key"."atype".
2025-03-30T15:38:54.089025Z WARNING Source column "public"."organization_api_key"."revision_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."organization_api_key"."revision_date".
2025-03-30T15:38:54.090025Z WARNING Source column "public"."org_policies"."atype" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."org_policies"."atype".
2025-03-30T15:38:54.091025Z WARNING Source column "public"."sends"."atype" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."sends"."atype".
2025-03-30T15:38:54.092025Z WARNING Source column "public"."sends"."password_iter" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."sends"."password_iter".
2025-03-30T15:38:54.093025Z WARNING Source column "public"."sends"."max_access_count" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."sends"."max_access_count".
2025-03-30T15:38:54.094025Z WARNING Source column "public"."sends"."access_count" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."sends"."access_count".
2025-03-30T15:38:54.094025Z WARNING Source column "public"."sends"."creation_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."sends"."creation_date".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."sends"."revision_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."sends"."revision_date".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."sends"."expiration_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."sends"."expiration_date".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."sends"."deletion_date" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."sends"."deletion_date".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."twofactor"."uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."twofactor"."uuid".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."twofactor"."user_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."twofactor"."user_uuid".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."twofactor"."atype" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."twofactor"."atype".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."twofactor_incomplete"."user_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."twofactor_incomplete"."user_uuid".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."twofactor_incomplete"."device_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."twofactor_incomplete"."device_uuid".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."twofactor_incomplete"."login_time" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."twofactor_incomplete"."login_time".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."twofactor_incomplete"."device_type" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."twofactor_incomplete"."device_type".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."users"."uuid".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."created_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."users"."created_at".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."updated_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."users"."updated_at".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."email" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."users"."email".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."password_iterations" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."users"."password_iterations".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."client_kdf_type" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."users"."client_kdf_type".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."client_kdf_iter" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."users"."client_kdf_iter".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."verified_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."users"."verified_at".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."last_verifying_at" is casted to type "timestamptz" which is not the same as "timestamp without time zone", the type of current target database column "public"."users"."last_verifying_at".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."login_verify_count" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."users"."login_verify_count".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."api_key" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."users"."api_key".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."avatar_color" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."users"."avatar_color".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."client_kdf_memory" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."users"."client_kdf_memory".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users"."client_kdf_parallelism" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."users"."client_kdf_parallelism".
2025-03-30T15:38:54.095025Z WARNING Source column "public"."users_collections"."user_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."users_collections"."user_uuid".
2025-03-30T15:38:54.099025Z WARNING Source column "public"."users_collections"."collection_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."users_collections"."collection_uuid".
2025-03-30T15:38:54.099025Z WARNING Source column "public"."users_organizations"."uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."users_organizations"."uuid".
2025-03-30T15:38:54.099025Z WARNING Source column "public"."users_organizations"."user_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."users_organizations"."user_uuid".
2025-03-30T15:38:54.099025Z WARNING Source column "public"."users_organizations"."org_uuid" is casted to type "char" which is not the same as "character varying", the type of current target database column "public"."users_organizations"."org_uuid".
2025-03-30T15:38:54.099025Z WARNING Source column "public"."users_organizations"."status" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."users_organizations"."status".
2025-03-30T15:38:54.099025Z WARNING Source column "public"."users_organizations"."atype" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."users_organizations"."atype".
2025-03-30T15:38:54.146026Z WARNING PostgreSQL warning: constraint "attachments_cipher_uuid_fkey" of relation "attachments" does not exist, skipping
2025-03-30T15:38:54.178027Z WARNING PostgreSQL warning: constraint "ciphers_collections_cipher_uuid_fkey" of relation "ciphers_collections" does not exist, skipping
2025-03-30T15:38:54.208027Z WARNING PostgreSQL warning: constraint "ciphers_collections_collection_uuid_fkey" of relation "ciphers_collections" does not exist, skipping
2025-03-30T15:38:54.223028Z WARNING PostgreSQL warning: constraint "collections_groups_collections_uuid_fkey" of relation "collections_groups" does not exist, skipping
2025-03-30T15:38:54.277029Z WARNING PostgreSQL warning: constraint "favorites_cipher_uuid_fkey" of relation "favorites" does not exist, skipping
2025-03-30T15:38:54.302029Z WARNING PostgreSQL warning: constraint "folders_ciphers_cipher_uuid_fkey" of relation "folders_ciphers" does not exist, skipping
2025-03-30T15:38:54.307029Z WARNING PostgreSQL warning: constraint "folders_ciphers_folder_uuid_fkey" of relation "folders_ciphers" does not exist, skipping
2025-03-30T15:38:54.330030Z WARNING PostgreSQL warning: constraint "collections_groups_groups_uuid_fkey" of relation "collections_groups" does not exist, skipping
2025-03-30T15:38:54.338030Z WARNING PostgreSQL warning: constraint "groups_users_groups_uuid_fkey" of relation "groups_users" does not exist, skipping
2025-03-30T15:38:54.353030Z WARNING PostgreSQL warning: constraint "ciphers_organization_uuid_fkey" of relation "ciphers" does not exist, skipping
2025-03-30T15:38:54.361031Z WARNING PostgreSQL warning: constraint "collections_org_uuid_fkey" of relation "collections" does not exist, skipping
2025-03-30T15:38:54.391030Z WARNING PostgreSQL warning: constraint "groups_organizations_uuid_fkey" of relation "groups" does not exist, skipping
2025-03-30T15:38:54.406031Z WARNING PostgreSQL warning: constraint "auth_requests_organization_uuid_fkey" of relation "auth_requests" does not exist, skipping
2025-03-30T15:38:54.414031Z WARNING PostgreSQL warning: constraint "organization_api_key_org_uuid_fkey" of relation "organization_api_key" does not exist, skipping
2025-03-30T15:38:54.421031Z WARNING PostgreSQL warning: constraint "org_policies_org_uuid_fkey" of relation "org_policies" does not exist, skipping
2025-03-30T15:38:54.436031Z WARNING PostgreSQL warning: constraint "sends_organization_uuid_fkey" of relation "sends" does not exist, skipping
2025-03-30T15:38:54.460032Z WARNING PostgreSQL warning: constraint "devices_user_uuid_fkey" of relation "devices" does not exist, skipping
2025-03-30T15:38:54.467032Z WARNING PostgreSQL warning: constraint "ciphers_user_uuid_fkey" of relation "ciphers" does not exist, skipping
2025-03-30T15:38:54.475032Z WARNING PostgreSQL warning: constraint "folders_user_uuid_fkey" of relation "folders" does not exist, skipping
2025-03-30T15:38:54.497033Z WARNING PostgreSQL warning: constraint "twofactor_user_uuid_fkey" of relation "twofactor" does not exist, skipping
2025-03-30T15:38:54.505033Z WARNING PostgreSQL warning: constraint "favorites_user_uuid_fkey" of relation "favorites" does not exist, skipping
2025-03-30T15:38:54.512033Z WARNING PostgreSQL warning: constraint "sends_user_uuid_fkey" of relation "sends" does not exist, skipping
2025-03-30T15:38:54.520033Z WARNING PostgreSQL warning: constraint "emergency_access_grantor_uuid_fkey" of relation "emergency_access" does not exist, skipping
2025-03-30T15:38:54.527033Z WARNING PostgreSQL warning: constraint "emergency_access_grantee_uuid_fkey" of relation "emergency_access" does not exist, skipping
2025-03-30T15:38:54.534033Z WARNING PostgreSQL warning: constraint "twofactor_incomplete_user_uuid_fkey" of relation "twofactor_incomplete" does not exist, skipping
2025-03-30T15:38:54.542034Z WARNING PostgreSQL warning: constraint "auth_requests_user_uuid_fkey" of relation "auth_requests" does not exist, skipping
2025-03-30T15:38:54.549034Z WARNING PostgreSQL warning: constraint "users_collections_user_uuid_fkey" of relation "users_collections" does not exist, skipping
2025-03-30T15:38:54.557034Z WARNING PostgreSQL warning: constraint "users_collections_collection_uuid_fkey" of relation "users_collections" does not exist, skipping
2025-03-30T15:38:54.564034Z WARNING PostgreSQL warning: constraint "users_organizations_user_uuid_fkey" of relation "users_organizations" does not exist, skipping
2025-03-30T15:38:54.572034Z WARNING PostgreSQL warning: constraint "users_organizations_org_uuid_fkey" of relation "users_organizations" does not exist, skipping
2025-03-30T15:38:54.579034Z WARNING PostgreSQL warning: constraint "groups_users_users_organizations_uuid_fkey" of relation "groups_users" does not exist, skipping
2025-03-30T15:38:57.272094Z LOG report summary reset
table name errors rows bytes total time
--------------------------- --------- --------- --------- --------------
fetch meta data 0 56 0.443s
Drop Foreign Keys 0 62 0.496s
--------------------------- --------- --------- --------- --------------
public.ciphers 0 341 370.7 kB 1.166s
public.ciphers_collections 0 292 21.1 kB 0.616s
public.devices 0 146 47.9 kB 1.132s
public.folders_ciphers 0 44 3.2 kB 0.638s
public.attachments 0 26 9.1 kB 1.253s
public.collections 0 26 4.6 kB 0.722s
public.users_collections 0 18 1.4 kB 1.221s
public.users_organizations 0 11 5.1 kB 0.755s
public.twofactor 0 9 1.3 kB 1.335s
public.folders 0 8 1.7 kB 0.796s
public.users 0 6 16.4 kB 1.338s
public.organizations 0 4 8.5 kB 0.614s
public.emergency_access 0 3 1.2 kB 1.106s
public.auth_requests 0 0 0.960s
public.twofactor_incomplete 0 2 0.2 kB 0.451s
public.event 0 0 0.969s
public.collections_groups 0 0 0.477s
public.groups 0 0 0.982s
public.favorites 0 0 0.563s
public.invitations 0 0 0.953s
public.groups_users 0 0 0.613s
public.org_policies 0 0 0.984s
public.organization_api_key 0 1 0.1 kB 0.667s
public.twofactor_duo_ctx 0 0 0.991s
public.sends 0 0 0.708s
--------------------------- --------- --------- --------- --------------
COPY Threads Completion 0 4 1.660s
Reset Sequences 0 0 0.101s
Create Foreign Keys 0 31 0.714s
Install Comments 0 0 0.000s
--------------------------- --------- --------- --------- --------------
Total import time ✓ 937 492.4 kB 2.475s
评论区