李大仁博客

--查出单个表的大小
SELECT pg_size_pretty(pg_relation_size('TABLENAME'));

-- 查出表大小按大小含Index
SELECT
"table_name",
pg_size_pretty(table_size) AS table_size,
pg_size_pretty(indexes_size) AS indexes_size,
pg_size_pretty(total_size) AS total_size
FROM (
SELECT
TABLE_NAME,
SUBSTRING("table_name",1,10) AS short_name,
pg_table_size(TABLE_NAME) AS table_size,
pg_indexes_size(TABLE_NAME) AS indexes_size,
pg_total_relation_size(TABLE_NAME) AS total_size
FROM (
SELECT ('"' || table_schema || '"."' || TABLE_NAME || '"') AS TABLE_NAME
FROM information_schema.tables
) AS all_tables
WHERE all_tables.table_name LIKE '%TABLENAME%'
ORDER BY total_size DESC
) AS pretty_sizes

server_name  www.lidaren.com lidaren.com;
return       301 https://www.lidaren.com$request_uri;

location / {
    rewrite ^(.*) https://www.lidaren.com$1 permanent
}

server {
    listen       80;
    server_name  www.lidaren.com lidaren.com;
 
# 方法一，使用Return方式，适用于全站HTTPS
    return       301 https://www.lidaren.com$request_uri;
 
# 方法二，rewirte方式转发特定目录，适用于子目录HTTPS化
# location 使用/根目录则全站跳转
#    location / {
#        rewrite ^(.*) https://www.lidaren.com$1 permanent
#    }
}

npm config set unsafe-perm true

npm config set unsafe-perm true

npm config set strict-ssl false

npm config set registry https://registry.npm.taobao.org

# socks5 proxy
npm config set proxy http://xx@xx.com:xxxx 
# http proxy
npm config set https-proxy=http://xx@xx.com:xxxx

wget https://jaist.dl.sourceforge.net/project/ta-lib/ta-lib/0.4.0/ta-lib-0.4.0-src.tar.gz
tar xf ta-lib-0.4.0-src.tar.gz 
cd ta-lib
# 安装到/usr
./configure --prefix=/usr
make
sudo make install

pip install TA-Lib

# /usr/share/autostartup/foobar.sh

/usr/share/autostartup/foobar.service

[Unit]
Description=foobar
Documentation=http://www.doc.com/doc.html
After=network.target
 
[Service]
Type=simple
WorkingDirectory=/home/foobar
ExecStart=/usr/share/autostartup/foobar.sh
ExecStop=/bin/kill -s QUIT $MAINPID
Restart=always
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=foobar
User=foobar
Group=foobar
Environment=
[Install]
WantedBy=multi-user.target

/usr/share/autostartup/demo-service.sh

chmod +x /usr/share/autostartup/demo-service.sh

chmod +x /etc/rc.d/rc.local

echo “/usr/share/autostartup/demo-service.sh” >> /etc/rc.d/rc.local