git clone https://github.com/keshe4ka/my_pi_server.git
cd my_pi_server
nano .env
Вставить переменные со значениями:
BOT_TOKEN=12345
USER_DB=user
PASSWORD_DB=12345
HOST_DB=localhost
PORT_DB=5432
pip3 install -r requirements.txt
или можно через poetry
sudo apt update && sudo apt upgrade && sudo apt install supervisor
sudo nano /etc/supervisor/supervisord.conf
В конец файла вставляем:
[include]
files = /etc/supervisor/conf.d/*.conf
sudo nano /etc/supervisor/conf.d/my_pi_server
Вставляем:
[program:my_pi_server_bot]
command=/usr/bin/python3 указать_путь_к/bot.py
user=pi
process_name=%(program_name)s
numproc=4
autostart=1
autorestart=1
redirect_stderr=true
stderr_logfile=/var/log/my_pi_server_bot.err.log
stdout_logfile=/var/log/my_pi_server_bot.out.log
sudo service supervisor start
sudo supervisorctl reread
sudo supervisorctl update
sudo apt install postgresql
sudo su - postgres
psql
create user myuser with encrypted password 'mypass';
create database my_pi_server;
grant all privileges on database my_pi_server to myuser;
\c my_pi_server
CREATE TABLE statistic (
id serial primary key,
cpu_temp real,
ram integer,
disk real,
date varchar(20),
time varchar(20)
varchar(80),
);
exit
sudo service supervisor start