PostgreSQL released the new beta 8 of their database server, a couple of days ago.

The best part is that they have now released a versions that run natively on Windows. This is great for the PostgreSQL because (most) developers like me use the Windows for web development. Although I have been working with PostgrSQL for couple of years now, but I had to run it with cygwin on windows, or work on Linux. Now I can work directly on Windows.

I downloaded and installed it. There is just one problem, it didn't install on a FAT32 file system, due to not being able set permissions on the FAT32, so it can only be installed on NTFS file system at the moment. So take this into account.

While we are on the topic, I use phpPGAdmin for the web adminsitration of the PostgreSQL.

Please do tell me what software, utilities or other resources like reference material, tutorials or security info do you guys use for the PostgreSQL.

P.S: As with all the beta software, this version is not ready for the production release, so please use it at your own risk.

• PostgreSQL 8 release notes
• PostgreSQL Windows Installer