macOS Big Sur由于新的安全性API打破了PostgreSQL

2021-01-30 21:49:35

$ pg_restore -d dbname --role username --no-password dbname-2021-01-21-0820.dumppg_restore:而处理TOC:pg_restore:来自TOC条目6072; 2606 2882021 CONSTRAINT产品products_pkey用户名pg_restore:错误:无法执行查询:错误:无法打开临时文件" base / pgsql_tmp / pgsql_tmp80511.72.sharedfileset / 0.0&#34 ;:中断的系统调用命令是:仅适用于ALTER TABLE .products添加约束产品products_pkey PRIMARY KEY(id); pg_restore:来自TOC条目5224; 1259 2882242索引address_verified_by_id用户名pg_restore:错误:无法执行查询:错误:无法打开临时文件" base / pgsql_tmp / pgsql_tmp80511.100.sharedfileset / 0.0&#34 ;:中断的系统调用命令是:CREATE INDEX address_verified_by_id ON public .address使用btree(verified_by_id); pg_restore:来自目录项5739; 1259 2882465 INDEX orderline_order_id用户名pg_restore:错误:无法执行查询:错误:无法打开临时文件" base / pgsql_tmp / pgsql_tmp80511.144.sharedfileset / 0.0&#34 ;:中断的系统调用命令是:CREATE INDEX orderline_order_id ON public .orderline使用btree(order_id); pg_restore:来自TOC条目5745; 1259 2882469 INDEX orderlinehistory_changed_by_id usernamepg_restore:错误:无法执行查询:错误:无法打开临时文件" base / pgsql_tmp / pgsql_tmp80511.148.sharedfileset / 0.0&#34 ;:中断的系统调用命令是:CREID INDEX orderlinehistory_changed_by .orderlinehistory使用btree(changed_by_id); pg_restore:来自目录项5769; 1259 2882480 INDEX payment_cancelled_by_id用户名pg_restore:错误:无法执行查询:错误:无法打开临时文件" base / pgsql_tmp / pgsql_tmp80511.159.sharedfileset / 0.0&#34 ;:中断的系统调用命令是:CREATE INDEXpayment_cancelled_by_id已打开.payment using btree(cancelled_by_id); pg_restore:来自目录项5844; 1259 2882515 INDEX paymentnotification_69dfcb07用户名pg_restore:错误:无法执行查询:错误:无法打开临时文件" base / pgsql_tmp / pgsql_tmp80511.176.sharedfileset / 0.0&#34 ;:中断的系统调用命令是:CREATE INDEX paymentnotification_69dfcb07 ON .paymentnotification使用btree(order_id); pg_restore:警告:恢复时忽略错误:6