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