PostgreSQL is an alternate DB that Drupal supports.
3
votes
4answers
180 views
Will the PHP filter prevent SQL injection attacks?
I had trouble getting the form API to work though I am considering re doing all my forms with it. I have some custom html/php forms however I directly insert into the DB using pg_query. I am looking ...
0
votes
1answer
39 views
Connecting to multiple databases of different type for form submission [duplicate]
I'm developing a GIS mapping system and for that I am using pgSQL, however I am bounded to using mysql for the drupal install because we use Drupal 6 mulitsites using mysql already. I know I can get ...
2
votes
1answer
153 views
DBTNG Migrate: SQLite -> PostgreSQL fails because of custom fields
I am trying to migrate a website from a development setup that uses SQLite as a database backend to a production environment, where PostgreSQL is used as a DBMS.
My research so far has led me to the ...
0
votes
1answer
128 views
PDOException when saving node with AudioRecorderField
Occurs on client's computer but not mine. Does not appear to be a user-related problem. Using SoundCloud recorder.
PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid
input ...
1
vote
1answer
63 views
Does drush sql-sync support inter-db syncing?
Can I use drush sql-sync between MySQL and PostgreSQL?
2
votes
2answers
907 views
Reasons to run Drupal on PostgreSQL
What would be the strongest reasons for running Drupal on PostgreSQL, in terms of available features and performance? I.e. what postgres features of that are supported by Drupal are not available on ...
7
votes
1answer
157 views
Any particular vacuum policy to increase performance using Drupal with PostgreSQL?
I'm running Drupal 7 with PostgreSQL as a Q&A (with a lot of nodes inserts/updates and several contrib modules). Do you recommand any particular pgsql vacuum policy on particular tables ?
1
vote
1answer
119 views
Does db_affected_rows() works well with PostgreSQL?
This is a clean installation and I was starting to develop a module.
So I have the following code (and nothing more apart from the hook_menu()):
$result = db_query("SELECT * FROM {variable}");
return ...
2
votes
4answers
947 views
Fatal error when restoring PostGreSQL DB from dump: undefined function system_run_automated_cron
I'm trying to simply install Drupal 7.8 on PostGreSQL 9.1, backup the DB, and then restore from it ... nothing else, just to test out backing up my sites, but the site will not come back up!
Here are ...
1
vote
2answers
1k views
How to disable persistent database connections for Drupal 7 / PostgreSQL
I have a Drupal 7.2 + CentOS 5.6/64 bit + PHP 5.3 + PostgreSQL 8.4.8 (servicing unix domain sockets only) web site which often goes down on peak times because of too many postmaster processes started.
...
7
votes
4answers
1k views
How to migrate from MySQL to PostgreSQL
I need to know how to migrate my Drupal 6 database from MySQL to PostgreSQL. I also like to hear first hand experience tales about actual migrations.
P.S. I found this drupal-mysql2pgsql.pl ...
