problem with pg_stat_activity view

Поиск
Список
Период
Сортировка
От Sofer, Yuval
Тема problem with pg_stat_activity view
Дата
Msg-id BE67D1149BBD5746984545ED91F702E001F4303A@hou-ex-02.adprod.bmc.com
обсуждение исходный текст
Ответы Re: problem with pg_stat_activity view  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:navy">Hello,</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="3"><spanstyle="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">postgres version:  8.2.0.4</span></font><p class="MsoNormal"><font color="navy"
face="Arial"size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy">platform windows: server 2008</span></font><p class="MsoNormal"><font color="navy"
face="Arial"size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">I check connections using: </span></font><p class="MsoNormal"><font color="navy"
face="Arial"size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">SELECT pg_stat_get_backend_idset()</span></font><p class="MsoNormal"><font
color="navy"face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">Now, I take the output and try to get the ip addresses using </span></font><p
class="MsoNormal"><fontcolor="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">select pg_stat_get_backend_client_addr(<integer>);</span></font><p
class="MsoNormal"><fontcolor="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">but for a local connection (simple login using psql), I get the next error:
</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">ERROR:  invalid input syntax for type inet:
"fe80::104d:416e:a8dc:c02e%12"</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">SQL state: 22P02</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="3"><spanstyle="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">The same error occurs for simple “select * pg_stat_activity” (of course, as it is
basedon the former function)</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">I noticed that for netstat –r –n, I got the next line (among the
others):</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">12    266 fe80::104d:416e:a8dc:c02e/128</span></font><p class="MsoNormal"><font
color="navy"face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">May the last 8 was removed and therefore the ip became illegal ? </span></font><p
class="MsoNormal"><fontcolor="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">Need your help </span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="3"><spanstyle="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">Thanks, </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Yuval Sofer<br /> BMC Software<br /> CTM&D Business Unit</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">DBA Team<br /> 972-52-4286-282<br /><a
href="mailto:yuval_sofer@bmc.com">yuval_sofer@bmc.com</a></span></font><pclass="MsoNormal"><font face="Times New Roman"
size="3"><spanstyle="font-size: 
12.0pt"> </span></font></div>

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Milen A. Radev"
Дата:
Сообщение: Re: psql: FATAL: Ident authentication failed for user "postgres"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: problem with pg_stat_activity view