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.

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: PostgreSQL_Installer_For_MacOSX.zip

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

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.