personalized paths, added pgsql aliases