Open link in a new tab

Content

Expand project menu

[PostgreSQL] Migration stops

Hi,

I try to migration from MySQL to PostgreSQL and having the following issue on Suse Enterprise 12:

sudo openproject run ./docker/mysql-to-postgres/bin/migrate-mysql-to-postgres
.
.
.
psql: FATAL:  no pg_hba.conf entry for host "::1", user "openproject", database "postgres", SSL off

I installed postgreSQL following these instructions: https://zypp.postgresql.org/howtozypp.php

Thanks for your help.

PS.: How does the Enterprise Support work? Over the forum here or did I miss something ;-)

Message actions

Your postgresql pga_hba.conf config prohibits the script from connecting. You will need to alter the configuration to allow it.

https://dba.stackexchange.com/a/84002

Best,

Oliver

Message actions

Thanks for the reply, it looks my password for PostgreSQL was too complex? When I used a much simpler one it worked. I did not use any special characters... a bit wired.