# Accessing Database

**URL:** https://meta.discourse.org/t/accessing-database/154125
**Category:** Self-hosting
**Created:** [June 7, 2020, 10:40pm UTC](https://meta.discourse.org/t/accessing-database/154125 "2020-06-07T22:40:54Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![EricGT](https://avatars.discourse-cdn.com/v4/letter/e/f1d935/32.png) [@EricGT](https://meta.discourse.org/u/EricGT)
#### Post date: [June 7, 2020, 10:50pm UTC](https://meta.discourse.org/t/accessing-database/154125/2 "2020-06-07T22:50:12Z")

</div>

> [@cmoi](#):
>
> `Any suggestions?`

If you only need a static snap shot of the database then from https://\<site\>/admin/backups download a backup. It should be a \*.tar.gz file and when uncompressed will be a \*.sql file. Create a PostgreSQL database on another machine, which could even be your laptop, and then import the \*.sql file.

Now you should be able to access the data all you want with any means that can connect to a PostgreSQL database.

I use the above but access the Discourse database in PostgreSQL via [ODBC](https://swi-prolog.discourse.group/t/swi-prolog-connecting-to-postgresql-via-odbc/2404).

HTH

---

_[View the full topic](https://meta.discourse.org/t/accessing-database/154125)._