Postgresql

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've been trying to install Drupal for a few days now on Fedora 6 with a PostgreSQL server, but when I reach the step where I have to configure the database I always get the same error: Can not connect to your PostgreSQL server. Are you sure you have the correct username and password etc...
Although I can login on to the PostgreSQL server from the PHPPgAdmin successfully.

It has been suggested to remove PostgreSQL support from Drupal 7 Core. If you don't want that to happen, help us in the surge for PostgreSQL:

• PostgreSQL surge #1: make simpletest works again
• PostgreSQL surge #2: add automated testing on PostgreSQL slaves
• PostgreSQL surge #3: make all tests pass on PostgreSQL

My company has been building a web application on top of a Drupal 5.x core and a PostgreSQL 8.1.11 base. We have seen that running Views with PostgreSQL slows drupal down to a snail and thus makes the site less enjoyable. We have enabled the Devel module and have been clocking the queries that run on each page and would like to know if there are any tweaks that we can do to Views or PostgreSQL configurations that might get the load time under 4 seconds. Here is an excerpt of the top 20 heaviest queries from one of our pages.

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?

Drupal 6.x. Table "node".

What should the value of the "language" field be if the displayed text is Chinese.

If a value is required, are there any other things that need to be done so that Chinese symbols are correctly displayed.

Any help appreciated.

Steve
http://prime357.org

ps. I've got a thread running at my site which I think this may be a part issue to it. As you can imagine it's becoming very confusing as all I see is either unicode or Chinese symbols (can't read Chinese).

I hope this is the right area for this question which refers to the 'thread' field of the table 'comments'. I provide a non php solution to convert Wordpress data to Drupal. I recently became aware that the thread field is not a string of decimal numbers but is in fact a string of base 36 (Vancode) numbers. I've created the necessary functions to convert to and from base 36 format but I'm a little confused re - the leading digit/character.

Here is an excerpt from http://api.drupal.org/api/function/int2vancode/5

<

blockquote>

[RESOLVED: see thread below]

I started in the regular support forums but they seem to be full of messages on the order of "I don't know anything about PostgreSQL, can anyone verify that it works?" That seemed rather odd to me given that Drupal supposedly now supports use of the PostgreSQL server.