PGPoolJUI is a simple web ui for PGPool made with Vaadin and Groovy. No database changes required, working with already existing PGPool database.

Account Summary

Instance Summary

Ban Statistics by Day

Allows you to return accounts to work, that was banned N days ago. Note, that it doesn't perform ban check. After this action PGPool may can allocate them for RocketMap, and map shuold perfom checks on its own.

Usage

RocketMap database should be created first.

Using prebuilded jar

Requires JRE 8

1. Download latest release.
2. Create application.properties file with flowing fields:

server.port=8282
spring.datasource.url=jdbc:mysql://localhost:3306/pgo
spring.datasource.username=
spring.datasource.password=

3. Change pgpool in database url for your DB name, username and password.
4. Start with

java -jar pgpooljui*.jar

Using latest source code

Requires JDK 8

1. git clone
2. Create application.properties same as above.
3. Build jar:

./gradlew build

4. Start with:

java -jar build/libs/pgpooljui*.jar

Additional Configuration

Running on non-root context with ngnix

In application.properties:

server.contextPath=/poolui

nginx configuration:

location /poolmap {
        proxy_pass http://localhost:8080/poolui;
        ... other stuff

Restrict remote connections

In application.properties:

server.address=127.0.0.1