Preparation

Have Postgresql installed: Download Page
Open a psql terminal:
- On Windows: Open any terminal, go to the postgres bin folder (default is
```
C:/Program Files/PostgreSQL/[Version Number]/bin
```
  ) and type
```
psql -U [username]
```
  "[username]" will probably be
```
postgres
```
  on your local computer.
- On Linux: switch to the postgres user:
```
sudo su postgres
```
  , then type
```
psql
```
Official Documentation if needed
Create a user called nldb:
```
CREATE USER nldb;
```
Create a database called nldb_new:
```
CREATE DATABASE nldb_new;
```
Connect to the newly created database:
```
\c nldb_new
```

Grant rights to the nldb user:

GRANT CREATE ON DATABASE nldb_new TO nldb;

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO nldb;

Extract the downloaded SQL dump

Exit the psql terminal if it\'s still open:
```
\q
```
Extract the downloaded dump into the database:
```
psql -U [username] nldb_new < C:/Path/To/Downloaded/File/NorthernlionDatabase_SQL_Dump.sql
```
[username] will probably be "postgres" again if you are doing this on a local computer.
Official docs on the topic: Backup-Dump

Next Step

> A description of table and data layout