Following on from this prior question, I'm trying to export a database from one server and put it on another using phpPgAdmin. My process is like this:
- select the database in server 1 and hit the export button
- select "data and structure and select the option in the dropdown "copy"
- create the a database of the same name in server 2 with the same name as the database from server 1
- select that database, open up the SQL pane, and paste the SQL code I downloaded from server 1
That's when I get the error:
ERROR: syntax error at or near "OWNED" LINE 73: ALTER SEQUENCE address_customer_id_seq OWNED BY address.cust...
Line 73 in its entirety is:
ALTER SEQUENCE address_customer_id_seq OWNED BY address.customer_id;
I've read here that it may be because I've have slightly different versions of PostgreSQL on my two servers. So I checked with the server tech, who said that, yes, there was that issue. So he upgraded server 2. I'm getting the same error however.
Any idea what could be going on?