On Monday, October 5, 2020, James B. Byrne <
byrnejb@harte-lyne.ca> wrote:
I am so confused by this. I tried to do this:
[root@accounting-2 ~ (master)]# psql -E --dbname=idempiere
--username=idempiere_dbadmin --host=localhost
Password for user idempiere_dbadmin:
psql (11.8)
Type "help" for help.
idempiere(5432)=# alter role "idempiere-dbadmin" set search_path = 'adempiere,
pg_catalog, public';
ERROR: role "idempiere-dbadmin" does not exist
idempiere(5432)=#
If the role idempiere-dbadmin does not exist then how did I connect to the
idempiere database?
Underscore versus hyphen.
David J.
