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?

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.

Backup fails on localhost with docker

Development

natasha_selvidge (Natasha) October 9, 2021, 7:04pm 8

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

Topic		Replies	Views
Backup restore failing on clean dev docker env: FATAL: Peer authentication failed for user “postgres” Bug pr-welcome , dev-install	14	4963	January 6, 2026
Backup failed with postgresql connection error Development	0	833	July 31, 2017
Cannot backup (connect to postgres) in docker_dev Bug	8	951	February 25, 2018
Discourse restore with pg_dump Self-hosting	2	1073	October 22, 2018
Documentation request: Overview about database access and configuration in a development environment. Site feedback	1	853	March 20, 2023

Backup fails on localhost with docker

Related topics