# Import Database
**URL:** https://meta.discourse.org/t/import-database/258144
**Category:** Self-hosting
**Created:** [March 14, 2023, 7:22pm UTC](https://meta.discourse.org/t/import-database/258144 "2023-03-14T19:22:15Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Timelord](https://meta.discourse.org/u/Timelord)
#### Post date: [March 14, 2023, 7:22pm UTC](https://meta.discourse.org/t/import-database/258144/1 "2023-03-14T19:22:15Z")
Team, have taken a backup of my site, extracted the contents to my local disk, and drilled down until I have gotten the dump.sql file.
Should it be possible to import this is into a local install of PostgrSQL on my workstation? It is fighting me back all the way, so I thought I would check to see if there are any gotchas I should know about.
When I say fighting back, it hangs the workstation, throws no errors, so it is frustrating.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [March 14, 2023, 10:31pm UTC](https://meta.discourse.org/t/import-database/258144/2 "2023-03-14T22:31:57Z")
> [@Timelord](#):
>
> Should it be possible to import this is into a local install of PostgrSQL on my workstation?
Yes. I usually do this by running discourse and restoring the whole thing, but you spoilt be able to restore the dump to postgres.
> [@Timelord](#):
>
> it hangs the workstation, throws no errors, so it is frustrating.
Is postgres or your os out of ram?
---
### Author:  [@mattdm](https://meta.discourse.org/u/mattdm)
#### Post date: [March 15, 2023, 12:17am UTC](https://meta.discourse.org/t/import-database/258144/3 "2023-03-15T00:17:47Z")
> [@Timelord](#):
>
> When I say fighting back, it hangs the workstation, throws no errors, so it is frustrating.
That does sound frustrating.
What exactly did you do, and at what point after that does it hang?
When you say “hang”, what does that mean? Does the command line process stop responding even to ctrl-c, but nothing else works? Or does everything become unresponsive? When that happens, does the mouse still move?
When whatever happens happens, is it all suddenly and at once, or does it get gradually worse (even if _quickly_ so)?
What is the hardware you are running this on? What else is going on on that system?
---
### Author:  [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [March 15, 2023, 2:33am UTC](https://meta.discourse.org/t/import-database/258144/4 "2023-03-15T02:33:31Z")
> [@Timelord](#):
>
> Should it be possible to import this is into a local install of PostgrSQL on my workstation?
Yes, it’s a standard pg\_dump file, so it can be restored as a normal PostgreSQL backup via either `psql` or `pg_restore`.