public inbox for [email protected]help / color / mirror / Atom feed
How to increase the max query history stored 3+ messages / 3 participants [nested] [flat]
* How to increase the max query history stored @ 2025-01-31 09:15 Bo Guo <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Bo Guo @ 2025-01-31 09:15 UTC (permalink / raw) To: [email protected] 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to increase the max query history stored @ 2025-04-15 16:22 Roland Müller <[email protected]> parent: Bo Guo <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Roland Müller @ 2025-04-15 16:22 UTC (permalink / raw) To: [email protected] 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 <[email protected]>: > 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 > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to increase the max query history stored @ 2025-04-15 17:00 Holger Jakobs <[email protected]> parent: Roland Müller <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Holger Jakobs @ 2025-04-15 17:00 UTC (permalink / raw) To: [email protected] PgAdmin questions should be discussed on the pgAdmin list, not on this one, which deals with PostgreSQL server -- Holger Jakobs, Bergisch Gladbach Tel. +49 178 9759012 Am 15. April 2025 18:22:09 MESZ schrieb "Roland Müller" <[email protected]>: >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 <[email protected]>: > >> 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 >> ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-04-15 17:00 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-01-31 09:15 How to increase the max query history stored Bo Guo <[email protected]> 2025-04-15 16:22 ` Roland Müller <[email protected]> 2025-04-15 17:00 ` Holger Jakobs <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox