Доброго времени, всем!
В целях тестирования надо поднять лог. репликацию на одном сервере (публикующий и подписчик на одном сервере).
Выполняю все необходимые действия, ни каких ошибок не возникает, однако слот репликации остается не задействован, walsender и logical replication worker не стартуют (но ошибок в логах не вижу).
db1 - публикующий
db2 - подписчик
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
db1=# \dRp
List of publications
Name | Owner | All tables | Inserts | Updates | Deletes | Truncates
-------------+----------+------------+---------+---------+---------+-----------
ta_15_pub | postgres | f | t | t | t | t
(1 row)
db1=# select * from pg_replication_slots \gx
-[ RECORD 1 ]-------+---------------------------------
slot_name | ta_15
plugin | pgoutput
slot_type | logical
datoid | 6269042
database | db1
temporary | f
active | f
active_pid |
xmin |
catalog_xmin | 2999147331
restart_lsn | 1535/ED55CF48
confirmed_flush_lsn | 1535/ED55CF80
db1=# select repl.*,slot.* from pg_replication_slots slot left join pg_stat_replication repl on slot.active_pid=repl.pid where slot.slot_type='logical'\gx
-[ RECORD 1 ]-------+---------------------------------
pid |
usesysid |
usename |
application_name |
client_addr |
client_hostname |
client_port |
backend_start |
backend_xmin |
state |
sent_lsn |
write_lsn |
flush_lsn |
replay_lsn |
write_lag |
flush_lag |
replay_lag |
sync_priority |
sync_state |
slot_name | ta_15
plugin | pgoutput
slot_type | logical
datoid | 6269042
database | db1
temporary | f
active | f
active_pid |
xmin |
catalog_xmin | 2999147331
restart_lsn | 1535/ED55CF48
confirmed_flush_lsn | 1535/ED55CF80
db1=# select datname,usename,application_name,client_addr,backend_type,state,wait_event_type,wait_event from pg_stat_activity where backend_type~'(sender)|(logical replication worker)|(Timescale)';
datname | usename | application_name | client_addr | backend_type | state | wait_event_type | wait_event
---------------------+----------+-----------------------------------------+--------------+-----------------------------------------+--------+-----------------+---------------
| postgres | TimescaleDB Background Worker Launcher | | TimescaleDB Background Worker Launcher | | Extension | Extension
db3 | postgres | TimescaleDB Background Worker Scheduler | | TimescaleDB Background Worker Scheduler | | Extension | Extension
db4 | postgres | TimescaleDB Background Worker Scheduler | | TimescaleDB Background Worker Scheduler | | Extension | Extension
db5 | postgres | TimescaleDB Background Worker Scheduler | | TimescaleDB Background Worker Scheduler | | Extension | Extension
| postgres | walreceiver | 172.25.82.25 | walsender | active | Activity | WalSenderMain
db6 | postgres | TimescaleDB Background Worker Scheduler | | TimescaleDB Background Worker Scheduler | | Extension | Extension
db7 | postgres | TimescaleDB Background Worker Scheduler | | TimescaleDB Background Worker Scheduler | | Extension | Extension
(7 rows)
db1=# select name, setting, context from pg_settings where name in ('wal_level','max_replication_slots','max_wal_senders');
name | setting | context
-----------------------+---------+------------
max_replication_slots | 10 | postmaster
max_wal_senders | 4 | postmaster
wal_level | logical | postmaster
(3 rows)
db1=# select name, setting, context from pg_settings where name in ('max_logical_replication_workers','max_worker_processes','max_replication_slots');
name | setting | context
---------------------------------+---------+------------
max_logical_replication_workers | 4 | postmaster
max_replication_slots | 10 | postmaster
max_worker_processes | 8 | postmaster
(3 rows)
db2=# select * from pg_subscription \gx
-[ RECORD 1 ]---+-------------------------------------------------------------------------------
subdbid | 6308121
subname | ta_15_sub
subowner | 10
subenabled | t
subconninfo | host=127.0.0.1 port=5432 user=postgres dbname=db1
subslotname | ta_15
subsynccommit | off
subpublications | {ta_15_pub}
Прогонял действия на др. серверах, все работает.
