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.conf file, and have all options set to trust. Would be great if I could get some assistance on how to get this to work. I tried on Ubuntu as well as on MacOSX. Everything else from the discourse instance is working fine on both (creating Posts, API…) except for the backup functionality.

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 container. white_check_mark Pros: No need to install any system dependencies, no configuration needed at all for setting up a development environment quickly. x Cons: Will be slightly slower than the native dev environment on Ubuntu, and much slower than a native install on MacOS. See also Developing Discourse using a Dev Container … As I said, everything works fine, except for the backup.

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 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	5017	January 6, 2026
Backup failed with postgresql connection error Development	0	841	July 31, 2017
Cannot backup (connect to postgres) in docker_dev Bug	8	981	February 25, 2018
Discourse restore with pg_dump Self-hosting	2	1092	October 22, 2018
Documentation request: Overview about database access and configuration in a development environment. Site feedback	1	865	March 20, 2023

Backup fails on localhost with docker

Related topics