path fixes, colors, and postgresql