Password authentication fails for herokupush access to localdatabase since the PGUSER is wrong but SET PGUSER=postgres doesnt seem to affect it.
pg_restore -h '[CREDURL]' -d [CREDNAME]< out.sql
At line:1 char:87
+ ... -[CREDURL]' -d d9u51l391ffjmf < out.sql
+ ~
The '<' operator is reserved for future use.
+ CategoryInfo : ParserError: (:) [], ParentContainsErrorReco
rdException
+ FullyQualifiedErrorId : RedirectionNotSupported