Backup fails on localhost with docker

[max-elia]

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.

[pfaffman (Jay Pfaffman)]

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

[max-elia]

Where could I change the user being used by discourse?

[pfaffman (Jay Pfaffman)]

How did you install?

[max-elia]

Following this tutorial:

Install Discourse for development using Docker

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. Pros: No need to install any system dependencies, no configuration needed at all for setting up a development environment quickly. 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.

[dmc]

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.

[natasha_selvidge (Natasha)]

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

[natasha_selvidge (Natasha)]

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

[helmi]

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.

[natasha_selvidge (Natasha)]

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.