Use PostgreSQL for WordPress Instead Of MySQL

MySQL is the preferred database for , however not everyone likes MySQL and there is no easy alternative to make WordPress use another database.

If you want to use PostgreSQL with WordPress there is a that will allow you to do it without making any changes to the internal WordPress codebase.

PostgreSQL for WordPress (PG4WP) gives you the possibility to install and use WordPress with a PostgreSQL database as a backend. It works by replacing calls to MySQL specific functions with generic calls that maps them to another database functions.

When needed, the original SQL queries are rewritten on the fly so that MySQL specific queries work fine with the backend database.

Support for other database can also be added if the appropriate drivers are written for them.

We tested this out on a local installation and were able to use PostgreSQL with WordPress without any issues.

The only problem we see with the plugin is that you need to perform a fresh install for this to work, however it might work on older installations if you are able to import the MySQL database to PostgreSQL.

Download PostgreSQL for WordPress (PG4WP)

Downgrade or Uninstall WordPress 2.8

2.8 is out, however lots of users are facing problems with the new installations, if you are someone who is facing problems and looking for a way to downgrade or uninstall WordPress 2.8 and use WordPress 2.7.1.

Here are the steps to downgrade WordPress 2.8 to WordPress 2.7.1, I assume that you have backups of your database with you, without the database  do not downgrade.

Note: I am providing these instructions for your reference, I take no liability if something goes wrong with your downgrade.

Most of the problems happening in installs in WordPress 2.8 is because of incompatible plugins and themes, please make sure you switch to the default theme and disable all plugins to see if it solves your problem before you make a decision to downgrade.

The downgrade process may take about 30minutes to an hour, so be prepared to have some downtime on your blog.

Step 1: Backup your current database and store it in a safe location, if anything goes wrong you can fall back on it later, here are some instructions on backing up your database, here are some questions with relation to Backing up WordPress.

Step 2: Delete all WordPress 2.8 files, to do this login to your FTP server and delete all files in the WordPress install except for wp-content folder and the wp-config.php file, you may also want to leave out other folders that are not related to WordPress.

Step 3: Download the WordPress 2.7.1 files and extract them to your local drive, upload all the files excluding the wp-content to your FTP server.

Step 4: Delete all the database tables in the WordPress database. Please make sure you have backups of your database before you do that.

Step 5: Restore the database backup you have before you upgraded to WordPress 2.8, you can find instructions on restoring your Database.

Step 6: Make sure everything works again and nothing is broken.

That’s it, hopefully this helps users who are seeing problems with their upgrade to WordPress 2.8.

Fix for Future Posts Not Posting In WordPress

Over the past few days we were facing a issue with the future posts feature in WordPress, while the future posts correctly showed a timer to the scheduled time, once it reached the scheduled it started in reverse direction and the timer went from 1 minute to 2 minutes and so on.

wordpress-logo To top that, we also had a issue where few of our post dated future posts published ahead of time. This was particularly frustrating and we checked several things such as server time, WordPress time stamp and other possible places where we could find out the problem.

Continue reading Fix for Future Posts Not Posting In WordPress