Home » Groups » Postgresql

Putting A PostgreSql Powered Drupal 6.x Site Online ??

Submitted by chalu on Tue, 2009-10-06 19:08
· ·

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.

Groups:
Postgresql
Login to post comments

probably need an older pg_dump

uwguy - Mon, 2009-10-26 04:20

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.


Login to post comments

using -Fc may also

Josh Waihi - Mon, 2009-11-09 00:15

using -Fc may also work:

pg_dump -Fc -f dump.sql --no-owner dbname
pg_restore -Fc -U drupaluser -d dbname dump.sql


Login to post comments