Hi James,
> On 03. Oct, 2020, at 04:17, James B. Byrne <byrnejb@harte-lyne.ca> wrote:
>
> On Fri, October 2, 2020 21:13, Tom Lane wrote:
>> "James B. Byrne" <byrnejb@harte-lyne.ca> writes:
>>> On Fri, October 2, 2020 18:46, Tom Lane wrote:
>>
>>> idempiere=# \dn
>>> List of schemas
>>> Name | Owner
>>> -----------+-----------
>>> adempiere | adempiere
>>> public | postgres
> I will resolve the conflict either by granting 'idempiere_dbadmin' the
> necessary privileges or by changing the connection to use the 'adempiere' user
> instead.
you can also rename roles/users:
alter role adempiere_dbadmin rename to idempiere_dbadmin;
https://www.postgresql.org/docs/13/sql-alterrole.html
or schema:
alter schema adempiere rename to idempiere;
https://www.postgresql.org/docs/13/sql-alterschema.html
Cheers,
Paul
