MIME-Version: 1.0
References: 
 <CADHFRcio+ziZ-j07dobdNPWpf8484UQJUKCLS=ptqh0PMY0Hbw@mail.gmail.com>
In-Reply-To: 
 <CADHFRcio+ziZ-j07dobdNPWpf8484UQJUKCLS=ptqh0PMY0Hbw@mail.gmail.com>
From: =?UTF-8?Q?Roland_M=C3=BCller?= <rolmur@gmail.com>
Date: Tue, 15 Apr 2025 19:22:09 +0300
Message-ID: 
 <CA+8p0G1kj1OG71cT9dEMjYuGzA6x1c0j=Z=GSc+Fdq1TwR6vvg@mail.gmail.com>
Subject: Re: How to increase the max query history stored
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b4a1640632d392de"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B8p0G1kj1OG71cT9dEMjYuGzA6x1c0j%3DZ%3DGSc%2BFdq1TwR6vvg%40mail.gmail.com>
Precedence: bulk

--000000000000b4a1640632d392de
Content-Type: text/plain; charset="UTF-8"

https://www.pgadmin.org/docs/pgadmin4/latest/config_py.html say's that the
file should be in the same directory as config.py.

I don't have the latest pgadmin but Ubuntu 22 too:

Here config.py is located at:
/usr/pgadmin4/web/config.py

BR,
Roland

Am Fr., 31. Jan. 2025 um 11:15 Uhr schrieb Bo Guo <bo.guo@gisticinc.com>:

> Hello there,
>
> The default size of 20 history queries is somewhat limiting. So, I tried
> to increase the size on my Linux server-installed (Ubuntu 22.04.5 LTS,
> Linux-6.8.12-7-pve-x86_64-with-glibc2.35) PGAdmn 8.14.  I followed the
> instructions below to no avail.  I appreciate any help!
>
> 1. Create /var/lib/pgadmin/config_local.py and add
> ON_DISK_HISTORY = True
> MAX_QUERY_HIST_STORED = 5000  # Set to your desired number of queries
>
> 2. Restart PGAdmin 4 with
> sudo systemctl restart apache2
>
> Thanks!
>
> Bo
>

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

<div dir=3D"ltr"><div><a href=3D"https://www.pgadmin.org/docs/pgadmin4/late=
st/config_py.html">https://www.pgadmin.org/docs/pgadmin4/latest/config_py.h=
tml</a> say&#39;s that the file should be in the same directory as config.p=
y.</div><div><br></div><div>I don&#39;t have the latest pgadmin but Ubuntu =
22 too:</div><div><br></div><div>Here config.py is located at:</div><div>/u=
sr/pgadmin4/web/config.py</div><div><br></div><div>BR,</div><div>Roland</di=
v></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"lt=
r" class=3D"gmail_attr">Am Fr., 31. Jan. 2025 um 11:15=C2=A0Uhr schrieb Bo =
Guo &lt;<a href=3D"mailto:bo.guo@gisticinc.com">bo.guo@gisticinc.com</a>&gt=
;:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"l=
tr"><div><font color=3D"#696969" face=3D"arial, helvetica, sans-serif">Hell=
o there,</font></div><div><font color=3D"#696969" face=3D"arial, helvetica,=
 sans-serif"><br></font></div><div><font color=3D"#696969" face=3D"arial, h=
elvetica, sans-serif">The=C2=A0default size of 20 history queries is somewh=
at limiting. So, I tried to increase the size on my Linux server-installed =
(</font>Ubuntu 22.04.5 LTS, Linux-6.8.12-7-pve-x86_64-with-glibc2.35)<span =
style=3D"color:rgb(105,105,105);font-family:arial,helvetica,sans-serif">=C2=
=A0PGAdmn 8.14.=C2=A0 I followed the instructions below to no avail.=C2=A0 =
I appreciate any help!</span></div><div><font color=3D"#696969" face=3D"ari=
al, helvetica, sans-serif"><br></font></div><div><font color=3D"#696969" fa=
ce=3D"arial, helvetica, sans-serif">1. Create /var/lib/pgadmin/config_local=
.py and add</font></div><div>ON_DISK_HISTORY =3D True<br>MAX_QUERY_HIST_STO=
RED =3D 5000 =C2=A0# Set to your desired number of queries<br></div><div><b=
r></div><div>2. Restart PGAdmin 4 with</div><div>sudo systemctl restart apa=
che2</div><div><br></div><div><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div><div dir=3D"ltr"><div><font color=3D"#669933" face=3D"a=
rial, helvetica, sans-serif"><span style=3D"font-size:10px"></span></font><=
/div><div>
Thanks!</div><div><br></div><div>Bo</div></div></div></div></div></div></di=
v>
</blockquote></div>

--000000000000b4a1640632d392de--