Content
[PostgreSQL] Migration stops
Started August 19, 2019 09:02 · 2 replies · 2 participants
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 ;-)
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
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.