我是PostgreSQL的新手。我已经成功创建了数据库,将“philipyoung”——我的ID设置为超级用户,并使用以下命令将本地数据库复制到elephantsql中的新服务器。
pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname
然后发生以下错误:
SET
SET
SET
SET
SET
ERROR: unrecognized configuration parameter "row_security"
ERROR: permission denied to create database
ERROR: role "philipyoung" does not exist
FATAL: no pg_hba.conf entry for host "xxx.xxx.xxx.xx", user "xxxx", database "xxxx", SSL on
任何帮助都将不胜感激