# NAME Pgtools - It's a yet another command-line tool for PostgreSQL operation. # SYNOPSIS ## pg\_kill $ pg\_kill -kill -print -mq "like\\s'\\%.\*\\%'" "192.168.32.12,5432,postgres,,dvdrental" ------------------------------- Killed-pid: 11590 At : 2016/03/21 01:32:29 Query : SELECT \* FROM actor WHERE last\_name like '%a%'; Killed matched queries! ## pg\_config\_diff $ pg\_config\_diff "192.168.33.21,5432,postgres,," "192.168.33.22,,,," "192.168.33.23,5432,postgres,,dvdrental" 192.168.33.21 192.168.33.22 192.168.33.23 -------------------------------------------------------------------------------------------- max\_connections 50 100 100 shared\_buffers 32768 16384 65536 tcp\_keepalives\_idle 8000 7200 10000 tcp\_keepalives\_interval 75 75 10 wal\_buffers 1024 512 2048 ## pg\_fingerprint $ pg\_fingerprint queries\_file SELECT \* FROM user WHERE id = ?; SELECT \* FROM user2 WHERE id = ? LIMIT ?; SELECT \* FROM user2 WHERE point = ?; SELECT \* FROM user2 WHERE expression IS ?; # DESCRIPTION Pgtools is composed of 3 commands which is pg\_kill, pg\_config\_diff, pg\_fingerprint. \- pg\_kill shows the specified queries during execution by regular expression and other options. And also kill these specifid queries by -kill option. \- pg\_config\_diff command needs more than 2 argument which is string to specify the PostgreSQL databases. \- pg\_fingerprint command converts the values into a placeholders. # LICENSE Copyright (C) Otsuka Tomoaki. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. # AUTHOR Otsuka Tomoaki