This is an automated email from the ASF dual-hosted git repository.
victorromero pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git
The following commit(s) were added to refs/heads/develop by this push:
new c34665e798 FINERACT-2517: Upgrade to Postgresql version 18 (#5564)
c34665e798 is described below
commit c34665e798d2e5398119c07c4f22ab1f833d6b17
Author: nidhibhawari <[email protected]>
AuthorDate: Mon Mar 2 13:08:52 2026 +0530
FINERACT-2517: Upgrade to Postgresql version 18 (#5564)
---
.github/workflows/build-postgresql.yml | 2 +-
.github/workflows/liquibase-only-postgresql.yml | 2 +-
.github/workflows/run-integration-test-sequentially-postgresql.yml | 2 +-
.github/workflows/verify-liquibase-backward-compatibility.yml | 2 +-
README.md | 2 +-
buildSrc/src/main/groovy/org.apache.fineract.dependencies.gradle | 2 +-
config/docker/compose/postgresql.yml | 2 +-
.../src/test/java/org/apache/fineract/command/CommandBaseTest.java | 2 +-
.../apache/fineract/integrationtests/SavingsAccountsExternalIdTest.java | 2 +-
.../test/java/org/apache/fineract/integrationtests/common/Utils.java | 2 +-
10 files changed, 10 insertions(+), 10 deletions(-)
diff --git a/.github/workflows/build-postgresql.yml
b/.github/workflows/build-postgresql.yml
index 5a523116f8..6e4841b55a 100644
--- a/.github/workflows/build-postgresql.yml
+++ b/.github/workflows/build-postgresql.yml
@@ -17,7 +17,7 @@ jobs:
services:
postgresql:
- image: postgres:18.2
+ image: postgres:18.3
ports:
- 5432:5432
env:
diff --git a/.github/workflows/liquibase-only-postgresql.yml
b/.github/workflows/liquibase-only-postgresql.yml
index 85d4c8aa5a..9767577bd6 100644
--- a/.github/workflows/liquibase-only-postgresql.yml
+++ b/.github/workflows/liquibase-only-postgresql.yml
@@ -12,7 +12,7 @@ jobs:
services:
postgresql:
- image: postgres:18.2
+ image: postgres:18.3
ports:
- 5432:5432
env:
diff --git a/.github/workflows/run-integration-test-sequentially-postgresql.yml
b/.github/workflows/run-integration-test-sequentially-postgresql.yml
index a7627212cc..22c7eb083a 100644
--- a/.github/workflows/run-integration-test-sequentially-postgresql.yml
+++ b/.github/workflows/run-integration-test-sequentially-postgresql.yml
@@ -14,7 +14,7 @@ jobs:
services:
postgresql:
- image: postgres:18.2
+ image: postgres:18.3
ports:
- 5432:5432
env:
diff --git a/.github/workflows/verify-liquibase-backward-compatibility.yml
b/.github/workflows/verify-liquibase-backward-compatibility.yml
index e714294bd4..17118a05f6 100644
--- a/.github/workflows/verify-liquibase-backward-compatibility.yml
+++ b/.github/workflows/verify-liquibase-backward-compatibility.yml
@@ -12,7 +12,7 @@ jobs:
services:
postgresql:
- image: postgres:18.2
+ image: postgres:18.3
ports:
- 5432:5432
env:
diff --git a/README.md b/README.md
index ca7a95b615..b9990d7d31 100644
--- a/README.md
+++ b/README.md
@@ -30,7 +30,7 @@ In the moment you get started writing code, please consult
our [CONTRIBUTING](CO
REQUIREMENTS
============
* min. 16GB RAM and 8 core CPU
-* `MariaDB >= 11.5.2` or `PostgreSQL >= 17.0`
+* `MariaDB >= 11.5.2` or `PostgreSQL >= 18.0`
* `Java >= 21` (Azul Zulu JVM is tested by our CI on GitHub Actions)
Tomcat (min. v10) is only required, if you wish to deploy the Fineract WAR to
a separate external servlet container. You do not need to install Tomcat to
run Fineract. We recommend the use of the self-contained JAR, which
transparently embeds a servlet container using Spring Boot.
diff --git a/buildSrc/src/main/groovy/org.apache.fineract.dependencies.gradle
b/buildSrc/src/main/groovy/org.apache.fineract.dependencies.gradle
index 1912865870..4ef727ee2d 100644
--- a/buildSrc/src/main/groovy/org.apache.fineract.dependencies.gradle
+++ b/buildSrc/src/main/groovy/org.apache.fineract.dependencies.gradle
@@ -250,7 +250,7 @@ dependencyManagement {
exclude 'org.slf4j:jcl-over-slf4j'
exclude 'org.slf4j:slf4j-api'
}
- dependency 'org.postgresql:postgresql:42.7.8'
+ dependency 'org.postgresql:postgresql:42.7.9'
dependency 'com.mysql:mysql-connector-j:9.3.0'
diff --git a/config/docker/compose/postgresql.yml
b/config/docker/compose/postgresql.yml
index 878c88264f..fecd9ca5c0 100644
--- a/config/docker/compose/postgresql.yml
+++ b/config/docker/compose/postgresql.yml
@@ -20,7 +20,7 @@ version: "3.8"
services:
postgresql:
- image: postgres:16.1
+ image: postgres:18.3
volumes:
-
${PWD}/config/docker/postgresql/docker-entrypoint-initdb.d/01-init.sh:/docker-entrypoint-initdb.d/01-init.sh:Z,ro
restart: always
diff --git
a/fineract-command/src/test/java/org/apache/fineract/command/CommandBaseTest.java
b/fineract-command/src/test/java/org/apache/fineract/command/CommandBaseTest.java
index 638a65ea6f..48f689f4c9 100644
---
a/fineract-command/src/test/java/org/apache/fineract/command/CommandBaseTest.java
+++
b/fineract-command/src/test/java/org/apache/fineract/command/CommandBaseTest.java
@@ -45,7 +45,7 @@ abstract class CommandBaseTest {
protected static Network network = Network.newNetwork();
@Container
- private static final PostgreSQLContainer<?> POSTGRES_CONTAINER = new
PostgreSQLContainer<>(DockerImageName.parse("postgres:16"))
+ private static final PostgreSQLContainer<?> POSTGRES_CONTAINER = new
PostgreSQLContainer<>(DockerImageName.parse("postgres:18.3"))
.withNetwork(network).withUsername("root").withPassword("mifos").withDatabaseName("fineract-test");
@Container
diff --git
a/integration-tests/src/test/java/org/apache/fineract/integrationtests/SavingsAccountsExternalIdTest.java
b/integration-tests/src/test/java/org/apache/fineract/integrationtests/SavingsAccountsExternalIdTest.java
index 8a642c4e5b..f6161c41aa 100644
---
a/integration-tests/src/test/java/org/apache/fineract/integrationtests/SavingsAccountsExternalIdTest.java
+++
b/integration-tests/src/test/java/org/apache/fineract/integrationtests/SavingsAccountsExternalIdTest.java
@@ -59,7 +59,7 @@ public class SavingsAccountsExternalIdTest extends
IntegrationTest {
request.setProductId(1L);
request.setLocale(locale);
request.setDateFormat(dateFormat);
- request.submittedOnDate(formattedDate);
+ request.setSubmittedOnDate(formattedDate);
request.setExternalId(EXTERNAL_ID);
Response<PostSavingsAccountsResponse> response =
okR(fineractClient().savingsAccounts.submitApplication2(request));
diff --git
a/integration-tests/src/test/java/org/apache/fineract/integrationtests/common/Utils.java
b/integration-tests/src/test/java/org/apache/fineract/integrationtests/common/Utils.java
index 383191c3d1..52fe052048 100644
---
a/integration-tests/src/test/java/org/apache/fineract/integrationtests/common/Utils.java
+++
b/integration-tests/src/test/java/org/apache/fineract/integrationtests/common/Utils.java
@@ -591,7 +591,7 @@ public final class Utils {
}
private static int getYear() {
- return 1000 + random.nextInt(1001);
+ return 2000 + random.nextInt(31);
}
private static int getMonth() {
