/check_postgres.pl -H host -p 5432 -db user_tools -dbuser db_tools -dbpass xxxxx -w 1 --action custom_query --query="select count(*) from sftp_uploader_queue where write_path like '%FobyRAM' and date_added > now() - interval '1 day'"
POSTGRES_CUSTOM_QUERY UNKNOWN: DB "db_tools" (host:host) Invalid format returned by custom query | time=0.36s count=422;1
I tried with warning and critical and this one with warning only and tried with neither warning or critical but then it moaned about at least having one.
Any ideas?
./check_postgres.pl -db root -dbuser root -w 1 --action custom_query --query="select count(*) as result from sftp_uploader_queue where write_path like '%FobyRAM' and date_added > now() - interval '1 day'"
(Added text was as result)
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
/check_postgres.pl -H host -p 5432 -db user_tools -dbuser db_tools -dbpass xxxxx -w 1 --action custom_query --query="select count(*) from sftp_uploader_queue as result where write_path like '%FobyRAM' and date_added > now() - interval '1 day'"
POSTGRES_CUSTOM_QUERY UNKNOWN: DB "db_tools" (host:host) Invalid format returned by custom query | time=0.33s count=423;1
Interestingly it does report the count = 423 in the output .
mindspring wrote:select count(*) from sftp_uploader_queue as result
dchurch wrote:select count(*) as result from sftp_uploader_queue
These two are not the same thing, SQL syntax-wise. You have to put "as result" after "count(*)", not after the table name.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.