搜索到
48
篇与
的结果
-
vsode 配置 先更新源sudo apt update安装最新版 VS Code（Microsoft 官方源）wget -qO- https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > packages.microsoft.gpg sudo install -D -o root -g root -m 644 packages.microsoft.gpg /etc/apt/keyrings/packages.microsoft.gpg echo "deb [arch=amd64,arm64,armhf signed-by=/etc/apt/keyrings/packages.microsoft.gpg] https://packages.microsoft.com/repos/code stable main" | sudo tee /etc/apt/sources.list.d/vscode.list rm -f packages.microsoft.gpg然后安装sudo apt update sudo apt install code安装 JetBrains Mono字体官方最简单的一键脚本（适用于 Linux）：/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/JetBrains/JetBrainsMono/master/install_manual.sh)"检查是否安装fc-list | grep -i "JetBrains Mono"配置字体settings.json 推荐加这些（Ctrl+, 打开设置 → 右上角打开 JSON）：{ "editor.fontSize": 16, "workbench.colorTheme": "PhpStorm Dark Islands", "editor.fontFamily": "'JetBrains Mono', Consolas, 'Courier New', monospace", "editor.fontLigatures": true, "window.zoomLevel": 1, }安装扩展按 Ctrl+Shift+X 打开扩展面板 → 搜上面名字 → Install。Chinese (Simplified) Laravel PHP Intelephense PhpStorm Dark Theme JetBrains IDE Keymap -
pgsql 用一个csv文件的数据，去表中查询结果并导出 1. 创建临时表CREATE TEMP TABLE tmp_uids (user_id BIGINT PRIMARY KEY);2. 把csv数据导入到临时表中\copy tmp_uids FROM '/tmp/uids_goods_20251215.csv' CSV;3. 生成数据（去重）到/tmp/result_goods_ids.csv\copy (SELECT DISTINCT b.goods_id FROM tmp_uids t JOIN public.goods b ON b.user_id = t.user_id AND b.goods_id != 0 ORDER BY b.goods_id) TO '/tmp/result_goods_ids.csv' WITH (FORMAT CSV, HEADER FALSE, ENCODING 'UTF8');4. 生成数据（不去重）到/tmp/result_goods_ids.csv\copy (SELECT b.goods_id FROM tmp_uids t JOIN public.goods b ON b.user_id = t.user_id AND b.goods_id != 0 ORDER BY b.goods_id) TO '/tmp/result_goods_ids.csv' WITH (FORMAT CSV, HEADER FALSE, ENCODING 'UTF8');5. 删除临时表DROP TABLE IF EXISTS tmp_uids;
-
自建邮箱pmail 仓库地址https://github.com/Jinnrry/PMail下载pmailcurl -L -O https://github.com/Jinnrry/PMail/releases/download/v2.8.7/linux_amd64.zip创建自启服务sudo vi /etc/systemd/system/pmail.service[Unit] Description=pmail [Service] ExecStart=/data/software/pmail/pmail_linux_amd64 Restart=always [Install] WantedBy=multi-user.target配置自启sudo systemctl enable pmail启动服务sudo systemctl start pmail特别注意25 端口可能被 CentOS 7 自带的 Postfix（master 进程）占用了，而且只监听在 localhost（127.0.0.1 和 ::1），说明它只是系统默认安装的空壳 MTA，几乎没啥用。 一键彻底解决（推荐做法，干净利落） Bash # 停掉并永久禁用系统自带的 postfix systemctl stop postfix systemctl disable postfix # 确认 25 端口已空 ss -ltnp | grep :25 # 应该什么都不输出 # 现在重启 pmail，它就能成功绑定 25 端口了 systemctl restart pmail systemctl status pmail
-
-
