Re: speed up a logical replica setup
| От | Euler Taveira |
|---|---|
| Тема | Re: speed up a logical replica setup |
| Дата | |
| Msg-id | 79088f3e-7b9d-4059-9b36-e5ee0bc3889b@app.fastmail.com обсуждение исходный текст |
| Ответ на | Re: speed up a logical replica setup (Shlok Kyal <shlok.kyal.oss@gmail.com>) |
| Ответы |
Re: speed up a logical replica setup
|
| Список | pgsql-hackers |
On Mon, Feb 19, 2024, at 7:22 AM, Shlok Kyal wrote:
I have reviewed the v21 patch. And found an issue.Initially I started the standby server with a new postgresql.conf file(not the default postgresql.conf that is present in the instance).pg_ctl -D ../standby start -o "-c config_file=/new_path/postgresql.conf"And I have made 'max_replication_slots = 1' in new postgresql.conf andmade 'max_replication_slots = 0' in the default postgresql.conf file.Now when we run pg_createsubscriber on standby we get error:pg_createsubscriber: error: could not set replication progress for thesubscription "pg_createsubscriber_5_242843": ERROR: cannot query ormanipulate replication origin when max_replication_slots = 0
That's by design. See [1]. The max_replication_slots parameter is used as the
maximum number of subscriptions on the server.
NOTICE: dropped replication slot "pg_createsubscriber_5_242843" on publisherpg_createsubscriber: error: could not drop publication"pg_createsubscriber_5" on database "postgres": ERROR: publication"pg_createsubscriber_5" does not existpg_createsubscriber: error: could not drop replication slot"pg_createsubscriber_5_242843" on database "postgres": ERROR:replication slot "pg_createsubscriber_5_242843" does not exist
That's a bug and should be fixed.
В списке pgsql-hackers по дате отправления: