Is it possible to request that you apply a license to this software? I assume you mean it to be free and open. Unfortunately, without a license, my company will not allow me to utilize this code. I appreciate your hard work, and find this plugin very helpful. Thank you

If you have servers without swap, the following two lines will fail, with failure to devide by zero. There needs to be a check to see if:

if ($mem->{swaptotal} == 0)

and some logic to just set the value to zero, rather than try to divide by it.
Regards,
Chris Frazee

for the obvious reasons..

My check_pgactivity nagios plugin script started erroring out after we upgraded PostgreSQL from 9.6 => 10. It appears that several function and variable names that used to end in "..._location" now end in "..._lsn" instead.

I got my script, with my particular set of options, working again:

==========
$ /lib64/nagios/plugins/check_pgactivity --service streaming_delta --host 127.0.0.1 -p 5432 --username postgres --dbname repltest
POSTGRES_STREAMING_DELTA OK: 1 slaves checked | '# of slaves'=1 'sent delta [email protected]'=0B 'wrote delta [email protected]'=0B 'flushed delta [email protected]'=0B 'replay delta [email protected]'=0B 'pid [email protected]'=4266
$
$ /lib64/nagios/plugins/check_pgactivity -V
check_pgactivity version 2.2_rc1, Perl 5.16.3

This diff listing summarizes the changes:

==========
$ diff check_pgactivity_original check_pgactivity
3403,3404c3403,3404
< pg_last_wal_receive_location(),
< pg_last_wal_replay_location()

                pg_last_wal_receive_lsn(),
                pg_last_wal_replay_lsn()

3406c3406
< ELSE pg_current_wal_location()

            ELSE pg_current_wal_lsn()

3409c3409
< WHEN 't' THEN pg_last_wal_replay_location()

            WHEN 't' THEN pg_last_wal_replay_lsn()

3758c3758
< WHEN pg_is_in_recovery() AND pg_last_wal_replay_location() <> pg_last_wal_receive_location()

        WHEN pg_is_in_recovery() AND pg_last_wal_replay_location() <> pg_last_wal_receive_lsn()

5313c5313
< (pg_wal_location_diff(pg_current_wal_location(), slot.restart_lsn)

            (pg_wal_location_diff(pg_current_wal_lsn(), slot.restart_lsn)

5523,5524c5523,5524
< sent_location, write_location, flush_location, replay_location,
< CASE pg_is_in_recovery() WHEN true THEN pg_last_wal_receive_location() ELSE pg_current_wal_location() END

        sent_lsn, write_lsn, flush_lsn, replay_lsn,
        CASE pg_is_in_recovery() WHEN true THEN pg_last_wal_receive_lsn() ELSE pg_current_wal_lsn() END

5527c5527
< sent_location, write_location, flush_location, replay_location,

        sent_lsn, write_lsn, flush_lsn, replay_lsn,

5531c5531
< sent_location, write_location, flush_location, replay_location,

        sent_lsn, write_lsn, flush_lsn, replay_lsn,

6425c6425
< ELSE pg_current_wal_location()

        ELSE pg_current_wal_lsn()

==========