postgresql postgres

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

I have Drupal 7.x-dev running on PHP 5.2.6 and PostgreSQL 8.2.9 on CentOS 5.2 x86_64. Haven't tried to do too much yet but OK so far.

Had trouble with the PGDG RPMs for PostgreSQL 8.3.4, they don't seem to be simple drop-in replacements for RHEL/CentOS packages but will try them again later.

I there anything specific I should be looking for PostgreSQL compatability-wise, or do I just keep trying things until something breaks?

I have a simple Drupal 6.4 installation running on PostgreSQL 8.1.6 (because that is what ships with Centos 5).
So far so good. However, I am evaluating Drupal for use with a large local government website which will probably grow quite complex.

How likely is it that we will run into problems using PostgreSQL with Drupal? For us, PostgreSQL is the non-negotiable part. We can always use another CMS but we have ruled MySQL out in favour of what we believe to be the more rigorous, capable and standards-compliant database.

Are we asking for trouble using Drupal with PostgreSQL?