org.postgresql.util.PSQLException: The connection attempt failed

1

I am using Postgres with liquibase and running in a Kubernetes cluster, I am getting connection attempt failed.
It is not showing any other details for the error.

below is my YAML file.
Please let me know if anyone has any idea
Thanks

apiVersion: v1
metadata:
  name: changelog-config-testrepo-suffix-pipeline-pr-11-52z
data:
  changelog.xml: |
    <?xml version="1.0" encoding="UTF-8"?>
    <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
                        xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
                        xmlns:pro="http://www.liquibase.org/xml/ns/pro"
                        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog   http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd   http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd   http://www.liquibase.org/xml/ns/pro http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd"
                        logicalFilePath="changelog.xml">
       <changeSet author="akansha" id="TEST-RDS">
          <createTable schemaName="RM" tableName="PHONE_NUMBER_MOVE">
             <column name="ID" type="NUMBER">
                <constraints primaryKey="true"/>
             </column>
          </createTable>
       </changeSet>
    </databaseChangeLog>
kind: ConfigMap
---
apiVersion: batch/v1
kind: Job
metadata:
  name: liquibase-testrepo-suffix-pipeline-pr-11-52z
  labels:
    app: liquibase
    tag: liquibase-testrepo-suffix-pipeline-pr-11-52z
spec:
  backoffLimit: 1
  ttlSecondsAfterFinished: 60
  activeDeadlineSeconds: 700
  template:
    metadata:
      labels:
        app: liquibase
    spec:
      volumes:
      - name: changelog-config
        configMap:
          name: changelog-config-testrepo-suffix-pipeline-pr-11-52z
      imagePullSecrets:
      - name: dtr-access
      restartPolicy: Never
      containers:
      - name: liquibase
        command:
        - /liquibase/liquibase
        env:
        - name: USERNAME
          value: postgres
        - name: PASSWORD
          value: postgres
        - name: COMMAND
          value: update
        args:
        - --url=jdbc:postgresql://<rds-postgres>:5432/database-1?user=postgres&password=postgres
        - --username=$(USERNAME)
        - --password=$(PASSWORD)
        - --classpath=/liquibase/lib/postgresql.jar
        - --changeLogFile=/liquibase/db/changelog/changelog.xml
        - $(COMMAND)
        image: <dtr-path>/liquibase:3.8.9
        volumeMounts:
        - name: changelog-config
          mountPath: /liquibase/db/changelog
1 Like
2

@akansha - Thanks for posting and welcome to the Liquibase forum!

I’m going to ask some folks on the team if anyone has an answer for you, but while we wait to hear from them, I have two questions:

  1. Are you still encountering this issue? If not, how did you resolve it?

  2. can you share the exact text of the error message you’re seeing?

Thanks,
Tabby