Postgres error

[hchor]

This doesn't load anymore when I use the template. I also can't edit the source files to try to fix it manually. I'd recommend finding a different way to deploy than heroku.

Database Initialization Error: no pg_hba.conf entry for host...

[thomrburg]

@hchor - see here: https://github.com/Requarks/wiki/issues/2949. The fix is to create a new (version 10) pg database via CLI, delete the original, and reattach the new as DATABASE.

[Johann-L-Pickard]

How would I migrate an existing verion? I have tried using pg_dump and restore, but it gives me errors as it still tries to allow me to create a new admin when I first start

Specifically I get this error :

delete from "locales" where "code" != $1 - update or delete on table "locales" violates foreign key constraint "pagehistory_localecode_foreign" on table "pageHistory"

[clayton-franceschetto]

How would I migrate an existing verion? I have tried using pg_dump and restore, but it gives me errors as it still tries to allow me to create a new admin when I first start

Specifically I get this error :

delete from "locales" where "code" != $1 - update or delete on table "locales" violates foreign key constraint "pagehistory_localecode_foreign" on table "pageHistory"

Same problem here.

[Johann-L-Pickard]

Strange thing is, I wiped the database, used pgadmin and attempted the restore again, and it worked. Dont think I did anything differently.

[dawikowski]

I have the same issue. @Johann-L-Pickard What did you do exactly?