原因是宿主机并没有监听其他的主机接口,因此没有建立连接。 默认postgresql 监听在127.0.0.1 的5432端口 1. 我们要修改配置文件,让它监听到所有外部ip请求, 修改配置文件/etc/postgresql/13/main/postgresql.conf 在listen_addresses注释这一行下面,加一行配置 listen_addresses='*' 表示监听所有ip过来的请求。 如果...
https://exchange.nagios.org/directory/Plugins/Databases/PostgresQL/check_postgres/details # tar zxfv check_postgres-2.11.1.tar.gz # rsync -av check_postgres-2.11.1/check_postgres.pl /usr/lib/nagios/plugins/ 显示数据库aa的连接数: # /usr/lib/nagios/plugins/check_postgres.pl --output=nagios ...
If you’ve changed from the default PostgreSQL port in your configuration, you will need to adjust your firewall rule to match. Checking PostgreSQL is Running on Red Hat, Fedora, Centos, etc Like Ubuntu and Arch, you can use thesystemctlcommand to check the status of the PostgreSQL service...
$ check_postgres.pl --action=connection --db=peiybdb POSTGRES_CONNECTION OK: DB"peiybdb"version10.4|time=0.14s $ check_postgres_locks --warning=100--critical="total=200:exclusive=20"POSTGRES_LOCKS OK: DB"postgres"total=1|time=0.00s peiybdb.total=0;100;200postgres.total=1;100;200template1...
Despite this error, there are alternative methods to check the PostgreSQL version via the command line. Use the-Von the postgress path as a workaround. To do so: 1. Use thelocatetool to find the PostgreSQL binary directory: locate bin/postgresCopy ...
First, the usage of tracer should be explicitly enabled by superuser by settingset plpgsql_check.enable_tracer to on;orplpgsql_check.enable_tracer to oninpostgresql.conf. This is a security safeguard. The tracer shows content of plpgsql's variables, and then some security sensitive information ...
The version of PostgreSQL that created the archives is only checked on the last one, for performance consideration. This service requires the argument --path on the command line to specify the archive folder path to check. Obviously, it must have access to this folder at the filesystem level...
yum install git postgresql coreutils jq golang # 如果已经安装过或者编译安装过,这里就不用yum二次安装了 1. 2 编译代码 git clone https://gitlab.com/postgres-ai/postgres-checkup.git # Use--branch to use specific release version. For example, to use version 1.1: ...
msg "Connection type (auto-detected): PostgreSQL ($HOST:$PGPORT)" fi export HOST fi dbg "CHECK_HOST_CMD: '${CHECK_HOST_CMD}'" dbg "HOST: '${HOST}'" dbg "_PSQL: '${_PSQL}'" dbg "_PSQL_NO_TIMEOUT: '${_PSQL_NO_TIMEOUT}'" ...
步骤1 源码包准备:通过官网下载Git,并上传至Linux主机中。 步骤2 执行命令rpm -ivh git-1.8.3.1-23.el7_8.x86_64.rpm --nodeps,解压源码包 步骤3 输入命令git --version,检查是否安装成功。 当出现以下回显时,表示安装成功。 ---结束安装Docker 以...