[postgres] Implement {backup,restore}_commands_env methods to remove annoying password prompts [reviewed]