Migration To PostgreSQL Failed

[BetterWP]

Dear,
I follow the instrucation but I got the following error I doubled check the credentiales it is correct Could you help? I am using Cloudflare if this make diffrence.

2024-07-14T06:48:25.044002Z LOG pgloader version "3.6.7~devel"
KABOOM!
DB-CONNECTION-ERROR: Failed to connect to pgsql at "postgresql" (port 5432) as user "****": Database error 28000: no pg_hba.conf entry for host "172.***", user "****", database "****", no encryption
An unhandled error condition has been signalled:
   Failed to connect to pgsql at "postgresql" (port 5432) as user "***": Database error 28000: no pg_hba.conf entry for host "172***", user "*****", database "*****", no encryption

[joseph]

@BetterWP Can you double check the postgres credentials? Use the postgres cli to double check this.

[joseph]

Connect to postgres like this (replace the variables below with the ones you put in pgloader):

export PGPASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD}
psql -h ${CLOUDRON_POSTGRESQL_HOST} -p ${CLOUDRON_POSTGRESQL_PORT} -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE}