Skip to content

xxsytriskxx/pgpooljui

 
 

Repository files navigation

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

image

Instance Summary

image

Ban Statistics by Day

image 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. image

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=
  1. Change pgpool in database url for your DB name, username and password.
  2. 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
  1. 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

About

Web UI for PGPool

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Java 69.6%
  • Groovy 30.1%
  • HTML 0.3%