I want to restore a dumped database. my starting point is a dump_name.sql.tar.gz file

:~$ sudo su - odoo

:~$ createdb [new_db_name]

:~$ tar -xvzf /[path/to/backup/dump_name.sql.tar.gz] | psql [new_db_name]

ERROR     syntax error at or near [dump_name]

LINE 1 dump_name.sql     # (has an up-arrow under the 'd' of dump_name)

any idea what the problem might be? It's not access rights. The [dump_name] that has been extracted is odoo:odoo & 775

I though I could try separate extractin the .tar file and attach the .sql file to my [new_database]. What would the command be for that