Technology, business
and innovation.

And, not least, about
the Mac.

Weblog • Archive • RSS

by: Bernard Teo

Joy of Tech ... from Geek Culture

Copyright © 2003-2010
Bernard Teo
Some Rights Reserved.

This work is licensed under a Creative Commons License.

The Ultimate Business Machine - Archives

List of Categories : Commentary * Singapore * Technology * Travel *

Sun 17 Jan 2010

PostgreSQL Installer

Category : Technology

This is Hai Hwee's PostgreSQL installer. It's almost done and will include a Preference Pane.

There's a Postgres installer for OS X at the Postgres site but it doesn't work very well. It changes some memory settings on the Mac, requires a reboot (always a sign that things are not quite right), and the Mac will refuse to go to sleep on its own after that. So we need our own installer.

So now, knowing how the OS X installer and preference pane work, we can easily make installers for custom builds of MySQL and PostgreSQL.

Between Maven and these installers, there's just one missing piece - something in Maven that will allow us to create database users and their access rights quickly and in a consistent way across the two databases. Once we have that done, it will be very easy to set up new database-driven web sites with just a few quick clicks. We should be able to get there soon.

Posted at 12:15PM SGT | permalink

Mac@Work
Put your Mac to Work

	Sivasothi.com? Now how would you do something like that?
	Weblogs. Download and start a weblog of your own.
	A Mac Business Toolbox A survey of the possibilities
	A Business Scenario How we could use Macs in businesses
	MailServe for Snow Leopard
	DNS Enabler for Snow Leopard
	DNS Agent for Snow Leopard
	WebMon for Snow Leopard
	Luca Accounting for Snow Leopard
	Liya for Snow Leopard
	Postfix Enabler for Tiger and Panther
	Sendmail Enabler for OS X Jaguar
	Liya for the iPhone
	Luca for the iPhone

Services running on this server, an iMac 2.66 GHz Intel Core 2 Duo, 4 GB RAM, 320 GB hard disk, Ethernet, Airport Extreme, Mac OS X 10.6.4 Snow Leopard:

• Apache 2 Web Server
• Postfix Mail Server
• Dovecot IMAP Server
• Fetchmail
• SpamBayes Spam Filter
• Procmail
• BIND DNS Server
• FTP Server
• WebDAV Server
• PHP-based weblog
• MySQL database
• PostgreSQL database

all set up using our own tools - MailServe, WebMon, DNS Enabler, DNS Agent and Liya, all on Snow Leopard.