从sql格式转储恢复pythonanywhere上的postgresql

Question

我将PythonAnywhere升级到99美元的启动计划，并创建了一个PostgreSQL数据库。PythonAnywhere数据库页面显示：Address: magula6-1249.postgres.pythonanywhere-services.com Port: 11249 Superuser role name: super我想从我的macbook上创建的pg-dump文件填充我的新数据库。我已经尝试了几种：$ psql -H magula6-1249.postgres.pythonanywhere-services.com -U super -p 11249 -f 2019_7_30_pgdump.sql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.11249"?我也尝试过:奇怪的是，postgres=# \i /home/magula6/cogswatch/2019_7_30_pgdump.sql tpsql:/home/magula6/cogswatch/2019_7_30_pgdump.sql:149: ERROR: function "function_correctiveaction" already exists with s ame argument types appears数据库页面显示：Postgres disk usage: 100% full (1.0 GB of your 1.0 GB quota)，但数据库显示为空：postgres=# \d No relations found.

Answer 1

答案是：

postgres=# grant usage on schema public to public; postgres=# grant create on schema public to public; postgres=# \d (我所有的表都会出现--太棒了)