The
Ultimate
Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog Archive Cutedge

by: Bernard Teo








Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

Fri 17 Aug 2012

New PostgreSQL 9.1.4 Installer for Mountain Lion

Category : Technology/PostgreSQL914Installer.txt

Okay, after quite a bit of trial and tribulation, I have a new PostgreSQL 9.1.4 database installer that will work on Mountain Lion. 

To edit these databases, just use Liya, an easy-to-use GUI for creating databases, tables, fields and data on these databases.

It's now ready for download by following the link, above.

Unfortunately version doesn't work on Lion. I'll have to find out why.

Also, I'm trying to build a new MySQL 5.5.27 installer but I keep having problems with cmake 2.8.8. I hate cmake.

Posted at 2:13PM UTC | permalink

PostgreSQL Installer for Mountain Lion

Category : Technology/PostgresInstallerForMLProgress.txt

My PostgreSQL Installer doesn't work on Mountain Lion. I've worked two weeks to find out that the problem is caused by a security measure taken by Apple to quarantine an object that it thinks has been downloaded from the Internet.

Let's say my friend, Hai Hwee, sends me the working files for the Postgres installer over the web. I open one of the scripts using TextEdit. Now, if I make a change to the script, TextEdit will most helpfully (not!) mark that script as quarantined, so it will refuse to run if executed from the Unix command line. But it does this marking most surreptitiously, as an extended file attribute, so you can't find anything amiss just by looking at the file or even listing it in Terminal.

That's what's causing my Postgres installer to fail in Mountain Lion. The installer couldn't run one script in the package - because it had been quarantined after being edited in TextEdit. 

Somehow, only TextEdit does that. TextWrangler doesn't. I wanted to remove TextEdit totally from my Mac, but I can't. The Mac says "it's needed by OS X".

So, I might as well work on a new version of the Installer. It'll include the very latest version of PostgreSQL.


Posted at 4:50AM UTC | 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

VPN Enabler for Mavericks

MailServe for Mavericks

DNS Enabler for Mavericks

DNS Agent for Mavericks

WebMon for Mavericks

Luca for Mavericks

Liya for Mountain Lion & Mavericks

Postfix Enabler for Tiger and Panther

Sendmail Enabler for Jaguar

Services running on this server, a Mac Mini running Mac OS X 10.9.2 Mavericks:

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

all set up using MailServe, WebMon, DNS Enabler, DNS Agent, VPN Enabler, Liya and our SQL installers, all on Mavericks.