I am new to posgresql.
I have just backed up my database, whose name is mydbname, using this command as indicated in pythonanywhere backup help:
$ pg_dump --host=myhost --port=myport --username=super --format=c --file=myfile.dump mydbname
The dump seems to be successful and I verified the .dump file.
But as the restore is not documented in pythonanywhere site, I was looking fir the right command and options and I tried this:
pg_restore --host=myhost --port=myport --username=super --create --exit-on-error --verbose myfile.dump
But it does not seem to create mydbname.
I then created the database manually (create database mydbname....)
Retried the same command, it was succussful, but it does not contain any relations????
Could you help me with the right options of pg_restore? I would like to restore structure and data!