Исходный код вики Соединение

Редактировал(а) Alexandr Fokin 2023/12/16 14:12
Последние авторы
1 |(% style="width:252px" %)[[Распределенные транзакции>>doc:Архитектура и модели.Группа\. Распределенные системы.Распределенные системы\. Консистентность.Распределенные транзакции.WebHome]]|(% style="width:1212px" %)(((
2 PostgreSQL: Documentation: 15: PREPARE TRANSACTION
3 [[https:~~/~~/www.postgresql.org/docs/current/sql-prepare-transaction.html>>https://www.postgresql.org/docs/current/sql-prepare-transaction.html]]
4
5 postgresql.conf max_prepared_transactions doesn't work
6 [[https:~~/~~/stackoverflow.com/questions/13617192/postgresql-conf-max-prepared-transactions-doesnt-work>>https://stackoverflow.com/questions/13617192/postgresql-conf-max-prepared-transactions-doesnt-work]]
7
8 PostgresException: 55000
9 )))
10 |(% style="width:252px" %)Имя соединения|(% style="width:1212px" %)(((
11 PostgreSQL: Set Application Name for each Session and Connection
12 [[https:~~/~~/www.dbrnd.com/2017/12/postgresql-set-application-name-for-each-session-and-connection-pg_stat_activity/>>https://www.dbrnd.com/2017/12/postgresql-set-application-name-for-each-session-and-connection-pg_stat_activity/]]
13
14 How to specify ApplicationName in NpgSql connection string
15 [[https:~~/~~/stackoverflow.com/questions/24046578/how-to-specify-applicationname-in-npgsql-connection-string>>https://stackoverflow.com/questions/24046578/how-to-specify-applicationname-in-npgsql-connection-string]]
16 )))
17 |(% style="width:252px" %)Подключение LAN|(% style="width:1212px" %)(((
18 |(% style="width:137px" %)postgresql.conf|(% style="width:1105px" %)(((
19 |(% style="width:212px" %){{code language="txt"}}listen_addresses = '*'{{/code}}|(% style="width:875px" %)ip адреса для принятия соединений
20 |(% style="width:212px" %){{code language="txt"}}lc_messages = 'utf-8'{{/code}}|(% style="width:875px" %)Кодировка соединения (для корректного вывода ошибок)
21 )))
22 |(% style="width:137px" %)pg_hba.conf|(% style="width:1105px" %)(((
23 |{{code language="txt"}}# TYPE DATABASE USER ADDRESS METHOD
24 # LAN access
25 host <databaseName>(all) <userName>(all) <clientIp>/<clientMask>(192.168.0.1/32 or all) <encryptionType>(scram-sha-256){{/code}}|Правила доступа для клиентских соединений
26 )))
27
28 Access PostgreSQL server from LAN
29 [[https:~~/~~/stackoverflow.com/questions/22080307/access-postgresql-server-from-lan>>https://stackoverflow.com/questions/22080307/access-postgresql-server-from-lan]]
30 )))
31
32