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