It has been a somewhat embarrassing secret. Until this weekend, pgedit.com was using MySQL for the content management system back end database. I intended to use PostgreSQL from the start, but the hosting provider only offered an old version (7.3) and there was a lack of necessary tools to run it properly. MySQL had an automatic installer that set everything up with a few mouse clicks.
Happily, pgedit.com is now running the latest version of Drupal and PostgreSQL 8. In addition to being a very nice content management system, Drupal provides a flexible framework for developing web database applications. There was a recent thread about this on the pgsql-general mailing list. Kevin Murphy pointed out the existence of some MySQL bias in the Drupal contributed modules and suggests the idea of a pool of Drupal/PostgreSQL testers to remedy the situation.
RE: 2 issues
(1) Don't use Fantastico. New versions of Drupal are easy to install. The only sort of hard part is making sure the database is setup.
(2) Find a host with a newer version of PostgreSQL. UTF8 has been the default encoding for PostgreSQL for a while. Otherwise you'll probably have to ask your hosting provider to create your database if you can't establish the encoding using cPanel.
2 issues
I am trying to install Drupal basing on PostgreSQL. Here are the problems I have encountered.
(1) Fantastico does provide Drupal scripts but it doesn't use PostgreSQL.
(2) Drupal requires UNICODE be used for databases. When I manually created PostgreSQL database through cpanel, it didn't ask me which encoding to be used for that database. I did not know that SQL_ASCII was automatically chosen before viewing it with phpPgAdmin. I need a way to choose UNICODE when creating PostgreSQL databases.
Any help?
Where to download PostgreSQL 8.3.1 and 8.2.7???
http://www.postgresql.org/
Where download PostgreSQL
Where download PostgreSQL 8.3.1 and 8.2.7???
Installing Drupal with PostgreSQL
Not quite definitive yet, but here is a start. I'll add some further tips and details later. Ask if you run into problems.
Getting Drupal up and running under PostGreSQL?
If it's not too much trouble, could you please explain the process used to get Drupal up and running under PostGres?
I can't seem to find any definitive HOWTO on this.