search

requarks / wiki-heroku

Heroku deploy manifest for Wiki.js
MIT License
49 stars 147 forks source link

Postgres error #26

Open hchor opened 3 years ago

hchor commented 3 years ago

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 commented 3 years ago

@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 commented 3 years ago

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"

image

clayton-franceschetto commented 3 years ago

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"

image

Same problem here.

Johann-L-Pickard commented 3 years ago

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

dawikowski commented 1 year ago

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