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: [image] 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 contai…

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.

Sauvegarde échoue sur localhost avec docker

Dev

natasha_selvidge (Natasha) Octobre 9, 2021, 7:04 8

Je l’ai résolu en ajoutant username: discourse directement dans mon database.yml. Merci !

Sujet		Réponses	Vues
Backup restore failing on clean dev docker env: FATAL: Peer authentication failed for user “postgres” Bug pr-welcome , dev-install	14	4963	Janvier 6, 2026
Backup failed with postgresql connection error Development	0	834	Juillet 31, 2017
Cannot backup (connect to postgres) in docker_dev Bug	8	951	Février 25, 2018
Discourse restore with pg_dump Self-hosting	2	1074	Octobre 22, 2018
Documentation request: Overview about database access and configuration in a development environment. Site feedback	1	853	Mars 20, 2023

Sauvegarde échoue sur localhost avec docker

Sujets connexes