Although the problem is fixed now it seems to reoccur every time I start msfconsole after starting postgresql.

Steps:

Code:
 service postgresql start
Code:
 msfconsole
Code:
 show auxiliary
Output: error while running command show.

But after a while of being in the framework, it works fine. Strange thing is, it only shows the error message when I use 'show auxiliary'. The others output normally: i.e 'show payload'

Any idea why the framework does this ? Further, when I run the show auxiliary without starting the postgresql db, no errors occur.

I'm on my phone so I'll edit later with screen shots and full detail output.