add app index, fix db yml for pgsql