PostgreSQL error messages confusing to new users

TESTIMONIALS

" Not only does Frank know how to squeeze every last bit of performance out of PostgreSQL and Linux -- he is happy to explain his tuning methods in plain English. Working with Frank not only makes your infrastructure better, it makes your people smarter. He was a great help setting up our infrastructure. Highly recommended. "

PostgreSQL error messages confusing to new users

In the spirit of my blog post last week, I've created a new page that shows a couple of the more common error messages that confuse newer PostgreSQL users. It is my intention to expand this over time as I see people having trouble.

If you have any error messages you feel should be included or you find any technical inaccuracies please post a comment and I'll include it on the page.

Comments

W/regards to the "root" problem, a simple hint would go far, something like, "...try the option -U postgres to connect as user postgres". An even longer explanation would not be out of line, as this is a "first impression" encounter and we want pg to look its best.

Posted by Kenneth Downs on May 24, 2007 at 6:12 AM