Postgresql

This group should probably have more organizers. See documentation on this recommendation.

Welcome to the Postgresql group. Hope we can find out a way how the Drupal code can be more accessible to PostgreSQL users. If you don't know what PostgreSQl is, don't panic; visit http://www.postgresql.org for more help. But please dont ask here specific postgresql questions. Thank you :)

looking for help porting a trigger to postgresql

Posted by Anonymous on April 3, 2010 at 9:12am

hi,

i've created this module:

http://drupal.org/project/settings_audit_log

which uses a trigger to watch the variable table, and i need help porting it to postgresql.

please drop by the issue queue if you can help.

PostgreSQL expert needed for security team issues

Posted by greggles on December 3, 2009 at 5:34pm

Hello,

The security team occasionally gets security issues which affect Drupal's interaction with PostgreSQL and sometimes the team has patches that will work on MySQL and break PostgreSQL, but do not receive enough reviews from PostgreSQL users prior to being released.

If you are
1. A PostgreSQL expert
2. Interested in joining the security team

Please send an email to security [at] drupal.org listing your interest and qualificiations.

PostgreSQL extensions on Snow Leopard

Posted by Darren Oh on October 8, 2009 at 3:48am

Philip Hofstetter wrote a good article on installing the pgsql extension on Snow Leopard. I followed the instructions and they work. The same steps work for the pdo_pgsql extension. This is important for Mac users.

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

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

Content image is not displaying

Posted by playground21 on September 12, 2009 at 10:46pm

Hi,

I have just installed Postgresql 8.4 then installed Drupal v6.12-1 through Stack Builder.
I have created some content and everything looks good so far. The image shows up in editing content but the image does show up in the shopping cart view and there is nothing in the imagecache directory.

Am I doing something wrong?

Thank you

Installation Problem when Connecting to PostgreSQL

Posted by ibtehal2001 on April 13, 2009 at 2:42pm

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.

Testing PostgreSQL 8.3 against HEAD

Posted by fiasco on March 11, 2009 at 5:30am

Is anyone running test on HEAD, until PostgreSQL testbeds are implemented we still need to ensure peoples are commiting broken code to HEAD that passes on MySQL. Can we get some kind of movement going to keep the testing up??

PostgreSQL surge spotlight

Posted by Crell on December 21, 2008 at 8:49pm
Last updated by Crell on Sun, 2008-12-21 20:49

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:

Remove PostgreSQL driver from core?

Posted by Anonymous on November 21, 2008 at 1:13am

that's what is being proposed here:

http://drupal.org/node/337146

some people from this group want to comment in that issue?

Drupal and PostgreSQL acceleration.

Posted by fumanchu182 on November 5, 2008 at 7:33pm

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.

pre>

PHP 5.2.6 pdo_pgsql is buggy with BLOB INSERT/UPDATE

Posted by hswong3i on October 25, 2008 at 1:19pm

Long story short, PHP 5.2.6 pdo_pgsql is buggy with BLOB INSERT/UPDATE. Both NULL and empty string are saved as NULL when pass into PostgreSQL, and so programming logic may break.

It is now fixed in latest PHP CVS, both 5.2.x and 5.3.x. All packages newer than snapshot php5.2-200810130030.tar.gz. is safe from this issue. Please refer to PHP bug report for more information.

As Drupal 7.x is now revamped with DBTNG and using PDO as the only default support database driver, this is a critical issue for its PostgreSQL support status. Patch is submitted and pending for review. Please refer to Drupal bug report for more information.

Fore more detail, please refer to my blog post.

Drupal 7 + PHP 5.2.6 + PostgreSQL 8.3.4

Posted by mickh on October 13, 2008 at 12:53pm

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?

Drupal 6.x. site Migration from MySQL to PostgreSQL (howto)

Posted by Alex Tutubalin on October 11, 2008 at 11:29am

I'm not a MySQL fun, so some troubles with MySQL database (MyISAM data corruption and too slow InnoDB) force migration of three existing Drupal 6 sites from MySQL to PostgreSQL. Since Drupal 6.2 some PgSQL-related bugs (sample) in core modules has been fixed, so I have a try.

Drupal 6.5 and PostgreSQL 8.3 compatibility

Drupal Core Modules

I've installed clean Drupal 6.5 on top of PostgreSQL 8.3.3 (with UTF8 database encoding) and played with it a lot. There is no heavy troubles, only minor ones:

Is Drupal + PostgreSQL a reliable combination?

Posted by mickh on October 6, 2008 at 1:07pm

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?

SimpleTests that are known to fail on PostgreSQL

Posted by Damien Tournoud on August 20, 2008 at 9:28pm

Here are the results of running our whole test suite on PostgreSQL 8.3.

Actions configuration 30 passes, 8 fails, 0 exceptions
See http://drupal.org/node/261859
Block functionality 57 passes, 1 fail, 0 exceptions
No known issue (yet!)
Blog API functionality 45 passes, 2 fails, 1 exception
No known issue (yet!)
Search engine ranking 21 passes, 5 fails, 20 exceptions
See http://drupal.org/node/296624
Module list functionality 53 passes, 4 fails, 0 exceptions
No known issue (yet!)

Table "Node" Field "language"

Posted by superjacent on June 20, 2008 at 4:45am

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).

Looking for Contributors - C++ (and other stuff in time)

Posted by superjacent on June 19, 2008 at 11:37am

Hope I'm not out of line with this request.

I'm now on the lookout for C++ contributors (and other like stuff in time). I started the site http://prime357.org, which is a separation from my personal blogging (http://superjacent.net - running) site, in early April this year. Too much geeky stuff was creeping into the running site.

Base 36 (Vancode) - leading digit/character

Posted by superjacent on June 6, 2008 at 12:13am

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>

Speakers needed: European PostgreSQL Day, Prato, Tuscany, Italy on October 17 and 18 2008

Posted by Amazon on April 29, 2008 at 7:44pm

Start:

2008-10-17 (All day) - 2008-10-18 (All day) GMT

Event type:

User group meeting

Drupal speakers are needed for PostgreSQL Day. If you are available or interested please contact me.

Installing Drupal with PostgreSQL 7.4

Posted by Altivo on March 25, 2008 at 6:02pm

[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.

Subscribe with RSS