[pgpool-general: 6670] improper log for application name

temp temp ttemp666 at gmail.com
Mon Aug 12 03:20:47 JST 2019


Hi,


I am not getting proper log
My connection string is :
const string
CONNECTION_STRING("DRIVER=PostgreSQL_unixODBC;DATABASE=mpsdb;SERVER=pgpool;PORT=5432;UID=mpsroot;PWD=somevalue;application_name=abcd;");



but in logs application name is still coming unknown

No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"application_name" value:""
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"client_encoding" value:"SQL_ASCII"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"DateStyle" value:"ISO, MDY"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"integer_datetimes" value:"on"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"IntervalStyle" value:"postgres"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"is_superuser" value:"on"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"server_encoding" value:"SQL_ASCII"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"server_version" value:"10.6"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"session_authorization" value:"mpsroot"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"standard_conforming_strings" value:"on"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: process parameter
status
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: backend:0
name:"TimeZone" value:"UTC"
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: authentication backend
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL:
cp->info[i]:0x7f0daf2cc000 pid:6525
[No Connection] : 2019-08-11 17:50:22: pid 63: DEBUG: sending backend key
data
[No Connection] : 2019-08-11 17:50:22: pid 63: DETAIL: send pid 6525 to
frontend
[unknown] : 2019-08-11 17:50:22: pid 63: DEBUG: selecting load balance node
[unknown] : 2019-08-11 17:50:22: pid 63: DETAIL: selected backend id is 0
[unknown] : 2019-08-11 17:50:22: pid 63: LOG: Query message from frontend.
[unknown] : 2019-08-11 17:50:22: pid 63: DETAIL: query: "select oid,
typbasetype from pg_type where typname = 'lo'"

Thanks in advance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190811/096977c8/attachment.html>


More information about the pgpool-general mailing list