On Mon, October 5, 2020 15:35, David G. Johnston wrote: > On Monday, October 5, 2020, James B. Byrne <byrnejb@xxxxxxxxxxxxx> 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. > Sigh. -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit sensitive data via e-Mail Unencrypted messages have no legal claim to privacy Do NOT open attachments nor follow links sent by e-Mail James B. Byrne mailto:ByrneJB@xxxxxxxxxxxxx Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3