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.

The Ultimate Business Machine - Archives

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

Thu 29 Nov 2012

New PostgreSQL 9.2.1 Installer

Category : Technology/PostgreSQL921.txt

I've built a new PostgreSQL 9.2.1 Installer. It's available here:

I've built it, this time, with these configuration parameters : '--with-pam' '--with-ldap' '--with-krb5' '--with-gssapi' '--with-bonjour' '--with-openssl' '--with-libxml' '--with-libxslt' '--with-perl' '--with-python' '--with-tcl'

And it should work on both Mac OS X 10.7 (Lion) and 10.8 (Mountain Lion).

I've tested that this latest build of Postgres can now authenticate against an LDAP database (set up by LDAP Enabler for Mountain Lion) via PAM. 

I have still to make all this PAM/LDAP goodness work with just one click but at least the mechanisms work and I'll get there eventually. The idea is that you can set up a single logon mechanism via the LDAP database, and with that one userID/password combination, a user can get into the email, database and any other system. Next - I've got to make this work also with MySQL, which surprisingly, is harder to do than with Postgres.

One more thing - I've been troubled that with I've had to create a postgres user in order to run my previous installers. There's already a _postgres user built into every Lion and Mountain Lion system and I ought to be using it. So I've finally figured out how to make everything work with that built-in _postgres user. So, if you use this latest 9.2.1 Postgres Installer, you can safely delete the postgres user from your users' list in the Users & Groups Preference Pane, after you've run the installer and upgraded your current Postgres installation to 9.2.1.

Posted at 8:58AM UTC | permalink

Put your Mac to Work 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.