pgsql scripts should check their input parameters

[Marsup]

Hi !

In some pgsql scripts, there is no exception raised when needed parameters are not present which causes unexpected behaviors. (in my case p_app_id missing from start_instance.pgsql)

We should have a review of all such cases.