Python-сообщество

sudo dnf install postgresql postgresql-server postgresql-contrib
sudo postgresql-setup --initdb
sudo systemctl enable postgres
sudo systemctl start postgres
sudo usermod -aG postgres

sudo -u postgres psql
create database test;
\l       -- list database
\d       -- list tables
\d table -- describe table

psql test
test=>

# to make user
CREATE USER guest WITH PASSWORD '';
# analog
createuser guest

# to make database owned by user
CREATE DATABASE test OWNER guest;
# analog
createdb --owner=guest test

# to enter by guest
sudo emacs -nw /var/lib/pgsql/pg_hba.conf
# change from
host all all 127.0.0.1/32 ident
# change to
host all all 127.0.0.1/32 trust

psql -h 127.0.0.1 test
psql -h 127.0.0.1 -U guest test

psycopg2==2.8.3

  
import psycopg2
 
conn = psycopg2.connect(длинная_ссылка_подключения)
conn.set_client_encoding(строка_кодировки)
cur = conn.cursor()
cur.execute(
    "INSERT INTO " + имя_таблицы +
    "(number,message) "
    "VALUES (%s, %s)",
    (1, 'test message')
)
conn.commit()
conn.close()

2020-04-09 04:34:20,410 (__init__.py:417 MainThread) ERROR - TeleBot: "A request to the Telegram API was unsuccessful. The server returned HTTP 409 Conflict. Response body:
[b'{"ok":false,"error_code":409,"description":"Conflict: terminated by other getUpdates request; make sure that only one bot instance is running"}']"
2020-04-09 04:34:52,501 (util.py:65 PollingThread) ERROR - TeleBot: "ApiException occurred, args=('A request to the Telegram API was unsuccessful. The server returned HTTP 409 Conflict. Response body:\n[b\'{"ok":false,"error_code":409,"description":"Conflict: terminated by other getUpdates request; make sure that only one bot instance is running"}\']',)
Traceback (most recent call last):
  File "D:\Programs\Python12\lib\site-packages\telebot\util.py", line 59, in run
    task(*args, **kwargs)
  File "D:\Programs\Python12\lib\site-packages\telebot\__init__.py", line 276, in __retrieve_updates
    updates = self.get_updates(offset=(self.last_update_id + 1), timeout=timeout)
  File "D:\Programs\Python12\lib\site-packages\telebot\__init__.py", line 246, in get_updates
    json_updates = apihelper.get_updates(self.token, offset, limit, timeout, allowed_updates)
  File "D:\Programs\Python12\lib\site-packages\telebot\apihelper.py", line 180, in get_updates
    return _make_request(token, method_url, params=payload)
  File "D:\Programs\Python12\lib\site-packages\telebot\apihelper.py", line 56, in _make_request
    return _check_result(method_name, result)['result']
  File "D:\Programs\Python12\lib\site-packages\telebot\apihelper.py", line 75, in _check_result
    raise ApiException(msg, method_name, result)
telebot.apihelper.ApiException: A request to the Telegram API was unsuccessful. The server returned HTTP 409 Conflict. Response body:
[b'{"ok":false,"error_code":409,"description":"Conflict: terminated by other getUpdates request; make sure that only one bot instance is running"}']
"
2020-04-09 04:34:52,501 (__init__.py:417 MainThread) ERROR - TeleBot: "A request to the Telegram API was unsuccessful. The server returned HTTP 409 Conflict. Response body:
[b'{"ok":false,"error_code":409,"description":"Conflict: terminated by other getUpdates request; make sure that only one bot instance is running"}']"

 [code][/code]