Re: Error pgbadger

--===============4701348929497222247==
Content-Type: multipart/alternative; boundary="000000000000c480b80567f05874"

--000000000000c480b80567f05874
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Cara esse limite e de arquivos abertos no limits do seu SO.
Aumente o valor para permitir mais arquivos abertos pelo usu=C3=A1rio que
execura o pgbadger e pronto seu problema acabou.


On Wed, 21 Mar 2018 at 15:07 Danilo Silva <[email protected]>
wrote:

> Pessoal,
>
> Estou gerando o report do pgbadger, por=C3=A9m, durante a gera=C3=A7=C3=
=A3o ocorre o
> seguinte erro: "Error in tempfile() using /tmp/tmp_pgbadgerXXXX.bin: Coul=
d
> not create temp file /tmp/tmp_pgbadgerBz_o.bin: Too many open files at
> /usr/bin/pgbadger line 1524" e o report n=C3=A3o =C3=A9 gerado.
>
> Penso que seja a quantidade de arquivos de log do postgres, sendo isso,
> qual o limite de arquivos?
>
> Estou gerando com as op=C3=A7=C3=B5es "-q" e "-j4"
>
> []s
> Danilo
> _______________________________________________
> pgbr-geral mailing list
> pgbr-geral-b/[email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

--=20
--
*Gerdan Rezende dos Santos*=E2=88=B4
Hortonworks, PostgreSQL & EnterpriseDB Specialist, Support, Training &
Services
+55 (61) 996 451 525

--000000000000c480b80567f05874
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div><div dir=3D"auto">Cara esse limite e de arquivos abertos no limits do =
seu SO.</div><div dir=3D"auto">Aumente o valor para permitir mais arquivos =
abertos pelo usu=C3=A1rio que execura o pgbadger e pronto seu problema acab=
ou.</div><div dir=3D"auto"><br></div><br><div class=3D"gmail_quote"><div>On=
 Wed, 21 Mar 2018 at 15:07 Danilo Silva &lt;<a href=3D"mailto:danilo.dsg.go=
[email protected]">[email protected]</a>&gt; wrote:<br></div><blockquo=
te class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc so=
lid;padding-left:1ex"><div><div class=3D"gmail_default" style=3D"font-famil=
y:arial,helvetica,sans-serif;color:rgb(0,0,0)">Pessoal,</div><div class=3D"=
gmail_default" style=3D"font-family:arial,helvetica,sans-serif;color:rgb(0,=
0,0)"><br></div><div class=3D"gmail_default" style=3D"font-family:arial,hel=
vetica,sans-serif;color:rgb(0,0,0)">Estou gerando o report do pgbadger, por=
=C3=A9m, durante a gera=C3=A7=C3=A3o ocorre o seguinte erro: &quot;Error in=
 tempfile() using /tmp/tmp_pgbadgerXXXX.bin: Could not create temp file /tm=
p/tmp_pgbadgerBz_o.bin: Too many open files at /usr/bin/pgbadger line 1524&=
quot; e o report n=C3=A3o =C3=A9 gerado.</div><div class=3D"gmail_default" =
style=3D"font-family:arial,helvetica,sans-serif;color:rgb(0,0,0)"><br></div=
><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-ser=
if;color:rgb(0,0,0)">Penso que seja a quantidade de arquivos de log do post=
gres, sendo isso, qual o limite de arquivos?</div><div class=3D"gmail_defau=
lt" style=3D"font-family:arial,helvetica,sans-serif;color:rgb(0,0,0)"><br><=
/div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans=
-serif;color:rgb(0,0,0)">Estou gerando com as op=C3=A7=C3=B5es &quot;-q&quo=
t; e &quot;-j4&quot;</div><div class=3D"gmail_default" style=3D"font-family=
:arial,helvetica,sans-serif;color:rgb(0,0,0)"><br></div><div class=3D"gmail=
_default" style=3D"font-family:arial,helvetica,sans-serif;color:rgb(0,0,0)"=
>[]s</div><div><div class=3D"m_-8610803286121817655gmail_signature"><div>Da=
nilo</div></div></div>
</div>
_______________________________________________<br>
pgbr-geral mailing list<br>
<a href=3D"mailto:pgbr-geral-b/[email protected]" target=3D"_blank">pg=
br-geral-b/[email protected]</a><br>
<a href=3D"https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-g=
eral" rel=3D"noreferrer" target=3D"_blank">https://listas.postgresql.org.br=
/cgi-bin/mailman/listinfo/pgbr-geral</a></blockquote></div></div>-- <br><di=
v dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature">=
<div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div dir=3D"lt=
r"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><span style=3D"font-s=
ize:small">--</span><br style=3D"font-size:small"><div style=3D"font-size:s=
mall"><div><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"l=
tr"><div dir=3D"ltr"><span style=3D"font-size:10pt;font-family:&quot;Courie=
r New&quot;"><tt><b>Gerdan Rezende dos Santos</b></tt></span><span style=3D=
"color:rgb(0,0,0);font-family:&quot;Helvetica Neue&quot;,Helvetica,Arial,sa=
ns-serif;font-size:13px">=E2=88=B4</span><span style=3D"font-size:10pt;font=
-family:&quot;Courier New&quot;"><br></span><span style=3D"font-size:10pt;f=
ont-family:&quot;Courier New&quot;">Hortonworks, PostgreSQL &amp; Enterpris=
eDB Specialist, Support, Training &amp; Services=C2=A0<br><tt>+55 (61) 996 =
451 525</tt></span></div></div></div></div></div></div></div></div></div></=
div></div></div></div></div></div></div></div>

--000000000000c480b80567f05874--

--===============4701348929497222247==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KcGdici1nZXJh
bCBtYWlsaW5nIGxpc3QKcGdici1nZXJhbEBsaXN0YXMucG9zdGdyZXNxbC5vcmcuYnIKaHR0cHM6
Ly9saXN0YXMucG9zdGdyZXNxbC5vcmcuYnIvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3BnYnIt
Z2VyYWw=

--===============4701348929497222247==--