Brian Wong <bwong@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin