Discourse restore with pg_dump

Hi,

I’m using default postgresql that comes with docker, I usually connect to database with

sudo ./launcher enter app
su -c 'psql discourse' postgres

As the default backups are stored at /var/discourse/shared/standalone/backups/default/,once I connect to app, then I will be landing at /var/www/discourse/, then i don’t see backup files here.

How can I dump postgreql backup from /var/www/discourse/, into discourse database. Example

psql disocurse < /var/discourse/shared/standalone/backups/default/bakup_dump.sql

The recommended way from inside the container is

discourse restore

The files are in

/shared/backups/default
4 Likes

Thank you. I tried that already, but it does not work, so thought to restore it using pg dump.