Alexander Kukushkin

Results 295 comments of 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)...