It is always good to have a development or test server for your project.
Source: http://drupal.org/documentation/installCreating a test site on a local computer
It is considered a good practice to do all development work on a separate test site before making changes to a production site. A test site allows you to evaluate the impact of upgrades, new modules, modifications to themes etc. without causing disruption to your live site. For information about setting up a web server on a local computer, see the Local Server Setup section of the Developing for Drupal guide.
Setting up a test server with PostgreSQL or MySQL is fairly well described in this
http://www.oopschool.com/phpBB3/viewtop ... f=11&t=174
thread. In addtion, we have explained how that is done on a WordPress http://www.oopschool.com/phpBB3/viewtop ... f=18&t=177
There is no main difference setting up a development server on your laptop or computer for other content management systems like Drupal. In addition it is well explained on the Drupal site:
http://drupal.org/node/157602
Install Drupal 7 on your Pc http://drupal.org/node/1065212 is even more specific:
Our bolding. There is even a related video http://www.acquia.com/resources/acquia- ... pal-distroIf you'd like to check out Drupal 7 on your PC you would normally have to install a web server stack like XAMMP or MAMP in order to do it. But there's lots of configuration steps required to use these apps, so unless you have some other specific requirement for them, why bother. The easiest way to install and set up Drupal on your PC is to use the Acquia Drupal Stack Installer; the so-called DAMP stack. In less than 10 minutes you'll have a fully functioning web stack and a full Drupal 7 installation to boot.
So we don't repeat the steps here. The "DAMP" stack installer includes Acquia Drupal, Apache, MySQL and PHP. We have not tried Drupal with the PostgreSQL database platform. If that is your preferred database plattform, http://bitnami.org/ may contain what you need or you may do the tweeking yourself and download and install Apache, php and PostgreSQL yourself.
It is our impression that both WordPress and Drupal is more http://bitnami.org/stack/drupal foccused on MySQL as the databaseplattform of choice. Why not be the first to write the book: "How to use PostgreSQL with different content management systems?"
The following query: which cms support OR "work with" postgresql
give some results that shows that it is (of course) possible to use PostgreSQL as the database plattform. A good platform is of course database plattform agnostic.
Source: https://help.ubuntu.com/community/DrupalDrupal is a robust Content Management System that runs on a LAMP server. The LAMP server uses MySQL by default, but PostgreSQL can also be used with Drupal.
Generally, be aware that not every WordPress plugin or Drupal module works seamless with another database platform. The devel is in the details.
Other examples: http://www.wolfcms.org/forum/topic565.html
Since this message board also has a Django subforum in the Python subforum, thisDue to a server only having PostgreSQL, I took the liberty to add support for this database to Wolf CMS. Surprisingly enough it was possible without any problems and the result is compatible, read no exceptions for any specific db, with both MySQL and SQLite.
Just like MySQL and SQLite I created a separate PostgreSQL file for the db initialization and I've integrated detection/selection for the db in the installation steps of Wolf CMS.
Migrating django(-cms) from sqlite to postgres: http://reinout.vanrees.org/weblog/2011/ ... o-postgres
thread may interest you.