In June 2019, I was at the PGDay Conference at Lyon. There were many interesting sessions. One of these sessions was about PgBadger. The session was animated by Gilles Darold - the author of the tool.
This post is a short synthesis of the session.
PgBadger is simple.
PgBadger is a transportab...
To access to a resources test in spring boot tests, you can use the following statement :
Paths.get(getClass().getResource(resourcePath).toURI());You can also use the spring annotation TestPropertySource on your test class :
@RunWith(SpringRunner.class)
@TestPropertySource(locations = "resou...By default, the user is connected on the 'public' schema. If you have specifics schemas, you must set search_path setting.
To do this for a specific database you can use the following statement :
ALTER USER test_user IN DATABASE test_database SET search_path TO schema1, schema2;To check the c...
When Postgresql is started, you can connect to it using psql tool like :
psql -h localhost -p 5432 -U postgresTo read the configurations, you can type the following command :
SHOW all; You can read a specific configuration like the max number of authorized connections
SHOW ma...Proxy management is an issue what we must manage in almost all projects. This article show how to configure proxy management into Java Application and into Apache Tomcat
Java Application
The proxy properties must be passed to the JVM by the following parameters :
http.proxyHost # define t...