PostgreSQL is an alternate DB that Drupal supports.
1
vote
2answers
1k views
Drush enable module | not working | Drupal 7 on WAMP with PostgreSQL
Based on this question -
Drush on windows - Command pm-enable needs a higher bootstrap level to run, i have the following question:
I have the same problem found here ...
1
vote
0answers
16 views
Postgres errors with Metatag module in combination with Drag and Drop File upload
After having migrated from a MySQL 5.5 to a Postgres 9.3 Database I encounter some issues in a Drupal OpenOutreach installation. I have a content type with a Drag & Drop Upload field to display ...
0
votes
2answers
34 views
Load The Drupal Database Schema in PostgreSQL
I was following the tutorial in the link below to install Drupal 7 with PostgreSQL.
http://pgedit.com/install_drupal
I'm stuck with step 3.
3.Load the Drupal database schema
Your Drupal ...
0
votes
1answer
17 views
settings and switching to external pgsql db
I am working with Drupal 7.3.4 and attempting to follow the instructions of changing settings.php so that I can switch to a pgsql DB within a module and then switch back to the default mysql after ...
5
votes
3answers
2k 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 ...
3
votes
3answers
2k views
Any way to do DISTINCT ON in Drupal?
I'm trying to create a query like this:
SELECT DISTINCT ON (field1, field2) field1, field2, field3 FROM table1
But can't figure out how to get DISTINCT ON narrowed down to a few fields in Drupal ...
1
vote
0answers
23 views
Create and update PostgreSQL view from Drupal view
Do you know about any way to automatically create and update PostgreSQL view from Drupal view? The reason is, that there are some applications, which can use DB view, but not Drupal one, such as QGIS ...
0
votes
1answer
28 views
SQL replace() function in PDO
I'd like to convert the instructions from this answer into a general script that can be reused across projects.
I'm wondering how these commands can be written in Drupal 7 PDO format:
UPDATE ...
0
votes
1answer
101 views
Does drush sql-sync support inter-db syncing?
Can I use drush sql-sync between MySQL and PostgreSQL?
0
votes
0answers
79 views
Adding a PostgreSQL database to settings.php causes update.php to fail with Error: Class 'DatabaseTasks_postgresql' not found in install.inc
In order to import some data from a PostgreSQL database to Drupal I added another entry to the databases array in settings.php.
After updating the modules and executing update.php Drupal returns this ...
0
votes
1answer
413 views
PDOException when saving node with AudioRecorderField [closed]
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
131 views
Drupal 7 connection to MS SQLServer/PostgreSQL [closed]
I'm building an architecture of an integrated system of databases that are going to be the infrastructure of about 60 websites.
since databases are going to be massive (more than 30000 articles will ...
0
votes
1answer
103 views
anonymous User broken
I just migrated the site from sqlite to Postgres, using the drush portabledb-import module
I'm getting a error page only when no user is logged in to the site.
I can get logged in using the ...
1
vote
1answer
854 views
drupal on postgresql vs mysql vs mariadb
Anybody using PostgreSQL with Drupal? I know MySQL is preferred for Drupal but I have an existing PostgreSQL instance running on the server. I might as well use it rather than use more resources by ...
0
votes
1answer
180 views
What data type is “Date” in Postgres?
I don't have access to a client database, but need to know how a "Date" CCK field stores its information.
I'm using MySQL, and this easily found in the structure of the table. Anyone use Postgres and ...
3
votes
4answers
1k 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
823 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
305 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 ...
7
votes
1answer
194 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 ?
3
votes
4answers
2k 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
2k 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.
...
8
votes
4answers
2k 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 ...
1
vote
1answer
144 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 ...
