dbax

Troubles with logical replication

6

**Describe the bug** We are using PostgreSQL logical replication (with debezium). And there are multiple logical replication processes per cluster. This is what pg_stat_replication shows: ``` database=# select pid,usename,application_name,client_addr,state from...

**Is your feature request related to a problem? Please describe.** We want to collect business metrics from databases. It requires running certain queries on specific databases only **Describe the solution...

Troubles with patroni metrics

5

**Describe the bug** Having troubles with reading patroni metrics: ``` {"level":"error","service":"pgscv","time":"2021-09-23T16:41:30+03:00","message":"patroni/common collector failed; Get \"http://[]:8008/liveness\": dial tcp: lookup : n$ such host"} ``` **Steps to reproduce** `sudo -u postgres ./pgscv...

allow-group-access clause in initdb seems not woking correctly

4

**Describe the bug** When using allow-group-access clause in initdb still have some files stlil created with 600 permisstions ``` find /data/postgresql/11/data/ -type f -perm 600 /data/postgresql/11/data/patroni.dynamic.json /data/postgresql/11/data/postgresql.base.conf.backup /data/postgresql/11/data/postgresql.conf.backup /data/postgresql/11/data/recovery.done ```...

Вопрос: как реализовать правильное подключение для снятия резервной копии с удаленного ведомого сервера

3

В документации сказано, что в командной строке или в файле pg_probackup.conf следует указывать параметр "remote-host" для снятия копии с удаленного сервера через ssh. Но как поступить в том случае, если...

Improvement idea. May be we should add pgbouncer monitoring too? Something like quiries: ``` show pools show clients show stats ``` Might be useful.

Error "WAL control functions cannot be executed during recovery" for pg_replication_slots

2

**What did you do?** Simply running exporter `0.0.1-rev (built with go1.15.8)` **What did you expect to see?** I expect no errors **What did you see instead? Under which circumstances?** ```...

Return value of "cz.startnet.utils.pgdiff.schema.PgSchema.getRelation(String)" is null

1

Running on MacOS: `java -jar apgdiff-2.6.0.jar one.sql another.sql` have: ``` Exception in thread "main" java.lang.NullPointerException: Cannot invoke "cz.startnet.utils.pgdiff.schema.PgRelation.addRule(cz.startnet.utils.pgdiff.schema.PgRule)" because the return value of "cz.startnet.utils.pgdiff.schema.PgSchema.getRelation(String)" is null at cz.startnet.utils.pgdiff.parsers.CreateRuleParser.parse(CreateRuleParser.java:74) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:275)...

Имеет ли смысл установка ПО в /usr/pgpro-9.6 вместо стандартного /usr/pgsql-9.6? Такая конфигурация создает лишние проблемы при установке сторонних расширений, например PostGIS, который по умолчанию устанавливается в /usr/pgsql-9.6/share/extension/postgis.control