Tag Archives: error

Shared memory fix for PostgreSQL Mac installation

3 Replies

EnterpriseDB have kindly created a one-click installer for PostgreSQL, but unfortunately it doesn’t work out-of-the-box, at least not on my MacBook Pro. The problem is down to the amount of shared memory that is configured in OS X; by default it is 4Mb, and PostgreSQL requires 32Mb:

Postgres installer error

The error message suggests looking at the README file, which actually doesn’t exist. Luckily, there’s a simple fix; to increase the shared memory to the required 32Mb, create or edit the /etc/sysctl.conf file and include the following lines:

kern.sysv.shmall=8192
kern.sysv.shmseg=64
kern.sysv.shmmni=256
kern.sysv.shmmin=1
kern.sysv.shmmax=33554432

Reboot your machine for the settings to take effect, and re-launch the PostgreSQL installer which should now work as normal.

Glen Scott

I’m a freelance software developer with 18 years’ professional experience in web development. I specialise in creating tailor-made, web-based systems that can help your business run like clockwork. I am the Managing Director of Yellow Square Development.

More Posts

Follow Me:
TwitterFacebookLinkedIn

The problem with complex error messages

1 Reply

Whilst I found myself agreeing with most of Jeff Atwood’s post The Problem With Logging, I strongly disagree with his third point:

If it’s worth saving to a logfile, it’s worth showing in the user interface. This is the paradox: if the information you’re logging is at all valuable, it deserves to be surfaced in the application itself, not buried in an anonymous logfile somewhere. Even if it’s just for administrators. Logfiles are all too often where useful data goes to die, alone, unloved and ignored.

This fails to take into consideration the two very distinct types of error messages that an application should have: administrator focused and user focused. Both of these error messages can be triggered by the same error condition. A problem occurs when you display administrator focused messages to the user: anyone that has come across largely meaningless error codes rather than a friendly human-readable language has experienced this less-than-valuable approach to logging.

useless error mesage

Good error messages are essential to any application, and so are adminstrator focused messages, but let’s remember these are two very distinct features and need to be separated as necessary.

Glen Scott

I’m a freelance software developer with 18 years’ professional experience in web development. I specialise in creating tailor-made, web-based systems that can help your business run like clockwork. I am the Managing Director of Yellow Square Development.

More Posts

Follow Me:
TwitterFacebookLinkedIn