Up to now I have configured postgres databases as described here: https://help.pythonanywhere.com/pages/PostgresGettingStarted
However for a database I created with: CREATE DATABASE targetdb WITH TEMPLATE sourcedb; I had to additionally do:
\c targetdb
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public to user1;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public to user1;
GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public to user1;
i.e. the
GRANT ALL PRIVILEGES ON DATABASE targetdb TO user1 ;
was not sufficient. Any idea why?