How to "reset" a postgres database on PythonAnywhere?

Question

After some testing with Django on PythonAnywhere, I want to get rid of my testing data before I import my actual data to the postgres database. I thought the best way would be to start from scratch and "reset" somehow the database.

Unfortunately there is no button for that on pythonanywhere.com and the documentation does not say anything.

So the question is: how can I "reset" or empty the postgres database on PythonAnywhere?

Ralf Zosel · Accepted Answer · 2021-02-13 09:33:10Z

1

With the help of the PythonAnywhere support I found a way which worked for me: I deleted and re-created my database (called my_db_name) as follows:

Open a bash console (not a virtualenv console!) and execute the following commands:

dropdb -h xxx.postgres.eu.pythonanywhere-services.com -p 10077 -U super my_db_name
createdb -h xxx.postgres.eu.pythonanywhere-services.com -p 10077 -U super my_db_name

(replace above xxx with your data)

edited Feb 13, 2021 at 9:33

answered Nov 9, 2020 at 21:59

Ralf Zosel

6931 gold badge7 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to "reset" a postgres database on PythonAnywhere?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related