Hello
I have zabbix 3.4 and my postgres 10.1 .conf settings set with
wal_level = replica
When i try to change that based on our previous postgre 9.4 conf file to
wal_level = minimal
zabbix fails to connect to database, when i change this back to replica (or even logical), all works fine...iam not sure why is that, this setting is desirable since it improved our old installation (zabbix 3.0 postgre 9.4) performance. Any suggestions why that may be?
zabbix log
1309:20180214:125549.628 database is down: reconnecting in 10 seconds
1264:20180214:125549.703 [Z3001] connection to database 'zabbix' failed: [0] could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
postgr service status
root@zabbix:~# service postgresql status
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Wed 2018-02-14 12:52:40 CET; 2min 56s ago
Process: 6750 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 6750 (code=exited, status=0/SUCCESS)
I have zabbix 3.4 and my postgres 10.1 .conf settings set with
wal_level = replica
When i try to change that based on our previous postgre 9.4 conf file to
wal_level = minimal
zabbix fails to connect to database, when i change this back to replica (or even logical), all works fine...iam not sure why is that, this setting is desirable since it improved our old installation (zabbix 3.0 postgre 9.4) performance. Any suggestions why that may be?
zabbix log
1309:20180214:125549.628 database is down: reconnecting in 10 seconds
1264:20180214:125549.703 [Z3001] connection to database 'zabbix' failed: [0] could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
postgr service status
root@zabbix:~# service postgresql status
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Wed 2018-02-14 12:52:40 CET; 2min 56s ago
Process: 6750 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 6750 (code=exited, status=0/SUCCESS)
Comment