PgAnalyzer is Protocol Analyzer for PostgreSQL. Uses libev and OpenSSL etc. Written in C language.
Sources, bug tracking: https://github.com/disco-v8/PgAnalyzer
PgAnalyzer depends on few things to get compiled...
- CentOS Linux 8+
- GNU Make 4.2+
- GNU Automake 1.16+
- Libev 4.24+
- OpenSSL 1.1.1+
etc ...
When dependencies are installed just run:
1) Download and compile, link.
$ git clone https://github.com/disco-v8/PgAnalyzer.git
$ cd PgAnalyzer
$ autoheader
$ aclocal
$ automake --add-missing --copy
$ autoconf
$ make clean
$ ./configure --prefix=/usr
$ make
ex. ./cleanmake.sh
2) Make PID, SockFile, Log's directorys.
$ mkdir /var/run/EvServer/
$ chown userid.groupid /var/run/EvServer/
$ mkdir /var/log/EvServer/
$ chown userid.groupid /var/log/EvServer/
3) Edit INI file, and run.
$ ./evs_pganalyzer [/PATH/TO/evserver.ini]
$ tail -F /var/log/EvServer/EvServer.log
ex. ./start.sh
4) Connect to PostgreSQL via PgAnalyzer.
$ psql test_db -U testuser -p 10080 -h testserver
Regards.
T.Kabu/MyDNS.JP