Alexander Kukushkin
Alexander Kukushkin
Well... Currently it works the same way as it was before 2.1.0. The unknown slot is removed when the new node joins the cluster.
> new postgres node join the cluster? Yes. Let's say there are node1 and node2 in the cluster. If node3 will join, any unknown replication slot is removed. It was...
> I checked it on version 2.1.0 and 1.6.5. Slots have been removed after few seconds I also just tried it with 1.6.5. When the cluster topology doesn't change unknown...
@sumukharaj you haven't checked postgres logs.
``` 2022-09-19 00:06:18.845 UTC,,,36076,,6327b279.8cec,3,,2022-09-19 00:06:17 UTC,,0,LOG,00000,"invalid primary checkpoint record",,,,,,,,,"" 2022-09-19 00:06:18.845 UTC,,,36076,,6327b279.8cec,4,,2022-09-19 00:06:17 UTC,,0,PANIC,XX000,"could not locate a valid checkpoint record",,,,,,,,,"" 2022-09-19 00:06:18.944 UTC,,,36072,,6327b274.8ce8,2,,2022-09-19 00:06:12 UTC,,0,LOG,00000,"startup process (PID 36076) was terminated...
> Basically can i edit the postgresql CRD instance (numberOfInstances attribute to 0) to stop/start the cluster? or is there a more graceful way of doing it. Patroni is a...
Please define "normally". The v3 API is supported via gRPC gateway. Nothing else is planned. https://patroni.readthedocs.io/en/latest/SETTINGS.html#etcdv3
There are more or less three reasons why pg_wal is growing: 1. checkpoints not happening (very unlikely) 2. unused replication slot 3. failing `archive_command` You need to investigate, find the...
Just look at these numbers: ```bash root@6a8677bfcf14:/home/postgres# time wal-g > /dev/null real 0m0.066s user 0m0.059s sys 0m0.040s root@6a8677bfcf14:/home/postgres# time wal-g > /dev/null real 0m0.080s user 0m0.064s sys 0m0.047s root@6a8677bfcf14:/home/postgres# time...
> Startup time is not affected by stripping the binary Interesting, thank you for checking it! > For a small binary like wal-g I am sorry, but 40MB (57MB non-striped)...