Сценарии

Версия 1.4 от Alexandr Fokin на 2023/05/08 12:15

PostgreSQL: Documentation: 15: PREPARE TRANSACTION
https://www.postgresql.org/docs/current/sql-prepare-transaction.html

postgresql.conf max_prepared_transactions doesn't work
https://stackoverflow.com/questions/13617192/postgresql-conf-max-prepared-transactions-doesnt-work

PostgresException: 55000

Имя соединения

PostgreSQL: Set Application Name for each Session and Connection
https://www.dbrnd.com/2017/12/postgresql-set-application-name-for-each-session-and-connection-pg_stat_activity/

How to specify ApplicationName in NpgSql connection string
https://stackoverflow.com/questions/24046578/how-to-specify-applicationname-in-npgsql-connection-string

Подключение LAN

postgresql.conf

listen_addresses = '*'	ip адреса для принятия соединений
lc_messages = 'utf-8'	Кодировка соединения (для корректного вывода ошибок)

pg_hba.conf

# TYPE DATABASE USER ADDRESS METHOD
# LAN access
host <databaseName>(all) <userName>(all) <clientIp>/<clientMask>(192.168.0.1/32 or all) <encryptionType>(scram-sha-256)

Правила доступа для клиентских соединений

Access PostgreSQL server from LAN
https://stackoverflow.com/questions/22080307/access-postgresql-server-from-lan