# Discourse restore with pg\_dump
**URL:** https://meta.discourse.org/t/discourse-restore-with-pg-dump/100157
**Category:** Self-hosting
**Created:** [October 22, 2018, 10:01am UTC](https://meta.discourse.org/t/discourse-restore-with-pg-dump/100157 "2018-10-22T10:01:06Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Lakshmi](https://meta.discourse.org/u/Lakshmi)
#### Post date: [October 22, 2018, 10:01am UTC](https://meta.discourse.org/t/discourse-restore-with-pg-dump/100157/1 "2018-10-22T10:01:06Z")
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`
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [October 22, 2018, 11:56am UTC](https://meta.discourse.org/t/discourse-restore-with-pg-dump/100157/2 "2018-10-22T11:56:30Z")
The recommended way from inside the container is
```
discourse restore
```
The files are in
```
/shared/backups/default
```
---
### Author:  [@Lakshmi](https://meta.discourse.org/u/Lakshmi)
#### Post date: [October 22, 2018, 12:15pm UTC](https://meta.discourse.org/t/discourse-restore-with-pg-dump/100157/3 "2018-10-22T12:15:33Z")
Thank you. I tried that already, but it does not work, so thought to restore it using pg dump.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [July 20, 2021, 11:41am UTC](https://meta.discourse.org/t/discourse-restore-with-pg-dump/100157/4 "2021-07-20T11:41:50Z")