Re: UUID generation problem - Mailing list pgsql-general

On Mon, October 5, 2020 12:06, Tom Lane wrote:
> "James B. Byrne" <byrnejb@harte-lyne.ca> writes:
>> On Mon, October 5, 2020 10:53, Tom Lane wrote:
>>> I continue to suspect that you are somehow
>>> confusing yourself by testing in different databases and/or
>>> with different user accounts.
>
>> Possibly.  I do not make any definitive claims at this point.  However, the
>> application properties of the DB connection are:
>
>> Connection=xyzCConnection[name\=accounting.harte-lyne.ca
>> {localhost-idempiere-idempiere_dbadmin},
>> AppsHost\=accounting.harte-lyne.ca,
>> WebPort\=8080,
>> SSLPort\=8443,
>> type\=PostgreSQL,
>> DBhost\=localhost,
>> DBport\=5432,
>> DBname\=idempiere,
>> BQ\=false,
>> FW\=false,
>> FWhost\=,
>> FWport\=0,
>> UID\=idempiere_dbadmin,
>> PWD\=xxxxxxxxxxxxxxxx]
>
> Hm, is "UID" really how they spell "database user name"?  Doesn't seem
> terribly consistent with the other field names you show here.

That is extracted directly from the properties file created by the install
process, excepting that the password has been edited.
>
>> [root@accounting-2 ~ (master)]# psql --dbname=idempiere
>> --username=idempiere_dbadmin
>
> psql, by default, is going to try to connect to a Unix socket.
> I wonder if you've got two postmasters on that machine and the
> other one is what's answering TCP port 5432. . .

I see only one master process

[root@accounting-2 ~ (master)]# ps -auwx | grep postgres
postgres  19108  0.0  0.2  177972   30540  -  IsJ  11:58    0:00.01 postgres:
idempiere_dbadmin idempiere 127.0.88.1(52228)  (postgres)
postgres  19109  0.0  0.2  178608   36876  -  IsJ  11:58    0:00.03 postgres:
idempiere_dbadmin idempiere 127.0.88.1(52229)  (postgres)
postgres  19110  0.0  0.3  182712   51688  -  IsJ  11:58    0:00.09 postgres:
idempiere_dbadmin idempiere 127.0.88.1(52230)  (postgres)
postgres  20028  0.0  0.2  178676   37624  -  IsJ  12:18    0:00.03 postgres:
idempiere_dbadmin idempiere 127.0.88.1(22758)  (postgres)
postgres  20029  0.0  0.2  178728   36784  -  IsJ  12:18    0:00.03 postgres:
idempiere_dbadmin idempiere 127.0.88.1(22759)  (postgres)
postgres  68949  0.0  0.2  175504   34656  -  IsJ  Fri18    0:00.85 postgres:
checkpointer    (postgres)
postgres  68950  0.0  0.1  175468   23420  -  SsJ  Fri18    0:00.82 postgres:
background writer    (postgres)
postgres  68951  0.0  0.1  175468   23416  -  SsJ  Fri18    0:01.48 postgres:
walwriter    (postgres)
postgres  68952  0.0  0.1  175800   23800  -  SsJ  Fri18    0:04.95 postgres:
autovacuum launcher    (postgres)
postgres  68953  0.0  0.1   32012   14076  -  SsJ  Fri18    0:18.87 postgres:
stats collector    (postgres)
postgres  68954  0.0  0.1  175644   23644  -  IsJ  Fri18    0:00.08 postgres:
logical replication launcher    (postgres)
root      20522  0.0  0.0   11348    2216  2  S+J  12:32    0:00.00 grep
--color=auto postgres
postgres  68947  0.0  0.1  175468   23408  2  SJ   Fri18    0:19.13
/usr/local/bin/postgres -D /var/db/postgres/data11

[root@accounting-2 ~ (master)]# service postgresql status
pg_ctl: server is running (PID: 68947)
/usr/local/bin/postgres "-D" "/var/db/postgres/data11"


>. . . You might try
> explicitly saying "--host=localhost" here.
>
>             regards, tom lane
>

[root@accounting-2 ~ (master)]#  psql --dbname=idempiere
--username=idempiere_dbadmin --host=localhost
Password for user idempiere_dbadmin:
psql (11.8)
Type "help" for help.

idempiere=# select current_schemas(true);
    current_schemas
------------------------
 {adempiere,pg_catalog}
(1 row)

idempiere=# select uuid_generate_v4();
ERROR:  function uuid_generate_v4() does not exist
LINE 1: select uuid_generate_v4();
               ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
idempiere=# select public.uuid_generate_v4();
           uuid_generate_v4
--------------------------------------
 5ba19b69-ec8e-4d8e-8968-7c84eccc4351
(1 row)



-- 
***          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@Harte-Lyne.ca
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