Posted by chalu on October 6, 2009 at 7:08pm
I tried to run Drupal 6 on PostgreSQL 8.3 instead of MySQL, and I must say I think it was better (no more strange MySQL errors), but now I am having problems migrating the database to the live site (PostgreSQL 7.x). I have tried using pg_dump but the SQL generated does not run on my live phpPgAdmin without errors (complaining about syntax errors near "OWNER") .
Here is what I did at the command line :
pg_dump -U postgres -s -O mydbname > mydbname.sql
By the way, I want to move both schema and data, but the -s option moves schema only. Please how do u guys move your postgresql powered site online.
Comments
probably need an older pg_dump
This is probably too late to be useful to you but I'd bet this would work if you used a pg_dump from the older version. So use a PostgreSQL 7.x pg_dump to connect to the PostgreSQL 8.3 server to actually create the dump for the live site running with PostgreSQL 7.x.
using -Fc may also
using -Fc may also work:
pg_dump -Fc -f dump.sql --no-owner dbnamepg_restore -Fc -U drupaluser -d dbname dump.sql