Sign inSign up

placidina/pg-tools

By placidina

•Updated almost 6 years ago

Image
0

50K+

placidina/pg-tools repository overview

⁠PG Tools

Simple tool to solve problems for PostgreSQL

⁠Requeriments

  • postgresql-libs
  • libconfig
  • gcc
  • cmake
  • make
  • linux-headers

⁠Build

Build default in container (required docker).

To build in locally:

git clone https://github.com/Placidina/pg_tools.git
cd pg_tools
mkdir build/
cd build/
cmake ../
make

⁠Usage Locally

pgtools version: b66de8cdff390d7883b91113e2d5c957cfb1a72e
Usage: pgt [-?hvudc] 

Options:
  -?,-h               : this help
  -v                  : show version and exit
  -c                  : set configuration file

⁠Available Modules

NameDescription
transactions/idleKill connections in idle in transactions
⁠Module Transaction Idle Configurations
NameTypeDescription
enabledBoolEnable or disable Idle module
timeoutIntInterval entry NOW() - state_change to kill transaction
sessionBoolEnable or disable to kill query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
...
idle = {
	enabled = true;
	timeout = 60;
	session = false;
};
...

Tag summary

Content type

Image

Digest

Size

145.9 MB

Last updated

almost 6 years ago

docker pull placidina/pg-tools