Again, Snoop InfoSystems got it running again, this time on the latest revision of PostgreSQL.
Points to remember:
- Create the database with the ENCODING set to SQL_ASCII. This is best achieved with a statement like "create database drupal with owner drupal tablespace drupal_default encoding 'SQL_ASCII'" where the tablespace statement is more for cosmetics (but I actually use it since the tablespaces are on different RAID sets). If one leaves it to the PostgreSQL 8 default, the encoding will be UNICODE. It would be nice if drupal supported this correctly though through detection of the ENCODING, or some option in the conf.php file.
Hearty recommendations:
- Use tablespaces. Postgres 8 supports them, and allows you to have the drupal user be the owner. If one runs multiple DBs on one server, this can save lots of headache.
- Use WAL (Write-ahead logging. This feature is actually very useful and allows you to recoved your DB more easily than with postgres 7.4.x.
- RTFM. There are lots of gems in the postgres manuals, especially about database management.
