I’m having issues with creating a backup from the admin section, running discourse from the docker container on localhost. The error I’m getting is: pg_dump: error: connection to database "discourse development" failed: FATAL: Peer authentication failed for user "postgres". I checked the pg_hba.c…

That could be a regression. It should be using user discourse, I’d think.

Where could I change the user being used by discourse?

Following this tutorial: [이미지] Install Discourse for development using Docker Developer Guides Developing using Docker Since Discourse runs in Docker, you should be able to run Discourse directly from your source directory using a Discourse development containe…

Hi Max! Were you able to fix this issue? I’m currently having the exact same problem, although I first detected it trying to make a restore on my local docker development install.

Hi @max-elia I’ve also run into this problem, were you able to get it fixed by any chance?

I fixed it by adding username: discourse directly into my database.yml. Thank you!

where in the file did you add it and what else did you do?? Adding it to the development section and simply restarting (d/shutdown_dev; d/boot_dev) didn’t do it for me.

Right under adapter: postgresql in the config/database.yml Then I followed the script/discourse restore <filename.of.the.backup.tar.gz> Which was what I was trying to accomplish.

로컬호스트에서 Docker로 백업 실패

개발

natasha_selvidge (Natasha) 10월 9, 2021, 7:04오후 8

database.yml에 username: discourse를 직접 추가해서 문제를 해결했습니다. 감사합니다!

글		댓글	조회수
Backup restore failing on clean dev docker env: FATAL: Peer authentication failed for user “postgres” Bug pr-welcome , dev-install	14	4963	1월 6, 2026
Backup failed with postgresql connection error Development	0	833	7월 31, 2017
Cannot backup (connect to postgres) in docker_dev Bug	8	951	2월 25, 2018
Discourse restore with pg_dump Self-hosting	2	1074	10월 22, 2018
Documentation request: Overview about database access and configuration in a development environment. Site feedback	1	853	3월 20, 2023

로컬호스트에서 Docker로 백업 실패

Related topics