# prefect

```shell
# https://docs.prefect.io/v3/how-to-guides/self-hosted/server-cli#use-postgresql
prefect config set PREFECT_API_DATABASE_CONNECTION_URL="postgresql+asyncpg://prefect:prefect123@sv-v2:5435/prefect"
prefect config view
prefect server start --host pc.lan
# http://pc.lan:4200/deployments
```

uv pip install universal_pathlib 

# 备份数据库
下载： https://www.mongodb.com/try/download/database-tools
文档 ： https://www.mongodb.com/docs/database-tools/
```shell
cd G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin

$timestr = Get-Date -Format "yyyyMMdd_HH_mm_ss";G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongodump.exe --uri="mongodb://sv-v2:27017" -o I:\eng\backup\mongo\$timestr

# 首先要加载 env 变量， J:\eng-sftp\nextcloud\eng\my-document\restic.md
restic backup G:\code\amazone\copywriting_production\output\mongodb_backup
restic snapshots -H pc
restic ls -l 04c9313f
```

## 备份集合到另一个数据库
```shell
G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongodump.exe --uri="mongodb://sv-v2:27017/amazone" --collection=Product -o G:\code\amazone\copywriting_production\output\temp
$timestr = Get-Date -Format "yyyyMMdd_HH_mm_ss"
echo $timestr
# 恢复到 test 数据库
G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongorestore.exe --uri="mongodb://sv-v2:27017/test" "I:\eng\backup\mongo\20250327_01_04_08\amazone\Product.bson"

G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongorestore.exe --uri="mongodb://mrh:123@sv-v2:27017" "I:\eng\backup\mongo\20250331_14_14_17"
G:\program\MongoDB\mongodb-database-tools-windows-x86_64-100.11.0\bin\mongorestore.exe --uri="mongodb://sv-v2:27017/backup_amazone" --collection=Product G:\code\amazone\copywriting_production\output\temp
mongoimport --uri="mongodb://sv-v2:27017" --collection=users --file=G:\code\amazone\copywriting_production\output\mongodb_backup\users.json
```