Brian Wong <bwong(at)imageworks(dot)com> writes:
> Any one has any clue how to fix this? ~ Brian
Well, you don't have adminpack installed in two out of those three
databases. Does it show up in the pg_available_extensions view?
If so, you just need "CREATE EXTENSION adminpack". If not, you
probably forgot to install the postgresql-contrib package (or
local equivalent).
regards, tom lane