Posts made by amith.kumar.shetty

@dan Thank you. I had to manually run the CREATE ROLE “postgresql@hostxxxx” LOGIN PASSWORD 'yyyyyyyyyy' on my database instance before starting the app. Then everything works ok. Note the double quotes around the username

I am connecting to postgres hosted on azure . Azure postgres requires the username to be specfied in username@hostname format. If I set the username like this, I get an error while starting the app.

com.inversoft.maintenance.db.JDBCMaintenanceModeDatabaseService - Exception caught executing [CREATE ROLE xxxxx@hostame WITH LOGIN PASSWORD xxxxxxxx]
org.postgresql.util.PSQLException: ERROR: syntax error at or near "@"
  Position: 23

Any method to fix this?