一、安装 openclaw (windows:git bash)

   curl -sSL https://openclaw.ai/install.sh | bash

二、deepseek 的配置

root@vm-openclaw:~/openclaw-setup# openclaw onboard
│
◇  Model/auth provider
│  Custom Provider
│
◇  API Base URL
│  https://api.deepseek.com/v1
│
◇  How do you want to provide this API key?
│  Paste API key now
│
◇  API Key (leave blank if not required)
│  sk-xxxxxx
│
◇  Endpoint compatibility
│  OpenAI-compatible
│
◇  Model ID
│  deepseek-chat
│
◇  Verification successful.

https://www.cnblogs.com/nihaorz/p/19674701

只导出数据，带insert和字段

sudo -u postgres pg_dump -U postgres -d $1 --column-inserts --data-only -t 表名1  -t 表名2   -f $2.sql

导入

#!/bin/bash
sudo -u postgres psql -U postgres -d $1 < $2

1、查看linux中的版本

dotnet --list-runtimes

2、编辑Dockerfile

echo 'FROM mcr.microsoft.com/dotnet/aspnet:6.0.25 AS runtime

# 添加中文字体到正确的位置
#COPY fonts/ /usr/share/fonts/

#时区
RUN cp -r -f /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \
    && echo -ne "timezone Asia/Shanghai. (`uname -rsv`)\n" >> /root/.built

WORKDIR /app' > Dockerfile

3、生成镜像

echo 'docker build -t $1 -f Dockerfile .' > build.sh

mkdir /etc/yum.repos.d/bak && mv /etc/yum.repos.d/*.repo  /etc/yum.repos.d/bak
cat > /etc/yum.repos.d/CentOS-Base.repo <<EOF
[baseos]
name=CentOS Stream 10 - BaseOS
baseurl=https://mirrors.aliyun.com/centos-stream/10-stream/BaseOS/$basearch/os/
enabled=1
gpgcheck=0

[appstream]
name=CentOS Stream 10 - AppStream
baseurl=https://mirrors.aliyun.com/centos-stream/10-stream/AppStream/$basearch/os/
enabled=1
gpgcheck=0
EOF

sudo dnf clean all
sudo dnf makecache
sudo dnf update -y

不区分大小写索引建立

drop index ems.sys_user_user_name;
create unique index   cclv_player_user_name     on ems.sys_user USING btree (LOWER(user_name));

字段不区分大小写

sudo tee /etc/yum.repos.d/pgdg-redhat-all.repo > /dev/null <<EOF
[pgdg-common]
name=PostgreSQL common RPMs for RHEL / Rocky \$releasever - \$basearch
baseurl=https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-\$releasever-\$basearch
enabled=1
gpgcheck=0

[pgdg14]
name=PostgreSQL 14 for RHEL / Rocky \$releasever - \$basearch
baseurl=https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-\$releasever-\$basearch
enabled=1
gpgcheck=0
EOF




sudo dnf makecache -y

sudo tee /etc/yum.repos.d/pgdg-redhat-all.repo > /dev/null <<EOF
[pgdg-common]
name=PostgreSQL common RPMs for RHEL / Rocky $releasever - $basearch
baseurl=https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1

[pgdg14]
name=PostgreSQL 14 for RHEL / Rocky $releasever - $basearch
baseurl=https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
EOF

sudo dnf install -y postgresql14-contrib

sudo -u postgres psql -d cclv_data -c "CREATE EXTENSION IF NOT EXISTS citext;"

ALTER TABLE ems.sys_user 
ALTER COLUMN user_name TYPE citext USING user_name::citext;