I am setting up a new PostgreSQL database with SDE and loading data however I'm running into an error saying that my database schema and username don't match. Here's the workflow.
I do not have a DBA background but am a GIS admin teaching himself how to administer PostgreSQL. I have another database machine with the same software versions where the workflow above worked without issue. I could easily blow away the database and users and re-create the whole thing but that does nothing to show me what the problem is and how to address it.
Any help would be appreciated.
I wonder if it has to do with the "_" in the schema name?
Can you try in a schema with out that character in it?