Cannot copy postgresql database to new server with error [unrecognized parameter "row_security"]
<p>I'm novice in PostgreSQL. I've succesfully created database, set "philipyoung"—my ID as super user, and use the command below, to copy local database to new server in elephantsql.</p>

<pre><code>pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname
</code></pre>

<p>and then the error below happens</p>



<pre><code>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
</code></pre>

<p>any help would be appreciated</p>