psql wants you to use an existing account. The two I created in OasisVM are 'openacs5' and 'dotlrn'
To load a script into openacs, try the following:
>su openacs5 >psql openacs5 openacs5=# \i myfirstpackage-create.sql