Linux 笔记

配置 sudo免密 bash $ sudo vi /etc/sudoers # 在最后一行添加,username 换成自己的 username ALL=(ALL:ALL) NOPASSWD: ALL

NGINX 笔记

配置 text server { listen 80; server_name xx.com; location / { proxy_pass http://127.0.0.1:8080; proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; proxy_set_header X-Forwarded-Port $server_port; proxy_connect_timeout 10s; proxy_send_timeout 60s; proxy_read_timeout 60s; } }

PostgreSQL 笔记

资料https://docs.microsoft.com/zh-cn/azure/postgresql/ https://dbaplus.cn/news-19-3523-1.html 配置 时区设置设置 database 的时区 text ALTER DATABASE postgres SET timezone TO 'Asia/Shanghai'; 临时修改当前连接的时区 text SET TIME ZONE "Asia/Shanghai"; 默认时区需要修改配置文件 postgresql.conf 修改后需重启 PostgreSQL 服务 text timezone = 'Asia/Shanghai' log_timezone = 'Asia/Shanghai'