v1.4.7

Version 1.4.7 (May, 25th 2025)

Major changes

• none this is mostly a monthly build, to refresh dependencies' versions

Minor changes

• built with Go 1.24.3

• rebuild of binaries with dependencies upgrades:

  • toolchain => go1.24.3
  • github.com/jackc/pgx/v5 => v5.7.5
  • golang.org/x/crypto => v0.38.0
  • golang.org/x/sys => v0.33.0
  • golang.org/x/text => v0.25.0

md5sum of binaries provided with the release

$ md5sum *
32f27013ac896e2d988fe6e24e67c82d  pgSimload
d7b1f55bbfa5d4d2b9deff88312a4db0  pgSimload_mac
af5e79e4cf520d65aab7c7c10a851a01  pgSimload_static
a205778cb2c190a6c67e7bf3e4a9bccc  pgSimload_static_non_stripped
0bb0e0c5fd1e4949fee1b7df9b9de9af  pgSimload_win.exe

v.1.4.6

Version 1.4.6 (April, 7th 2025)

Major changes

• none this is mostly a monthly build, to refresh dependencies' versions

Minor changes

• rebuild of binaries with dependencies updates:
  • upgraded golang.org/x/crypto to v0.37.0
  • upgraded golang.org/x/sys to v0.32.0
  • upgraded golang.org/x/text to v0.24.0
  • upgraded github.com/jackc/pgx/v5 to v5.7.4

md5sum of binaries provided with the release

$ md5sum *
94fcfc18e4623886a64a5e1c92464fb3  pgSimload
3bb2c403777553b55d544959a545538e  pgSimload_mac
7b635a73bfe39f24d4b9fbe86a99b9d8  pgSimload_static
768062c0ffd4d6435088728c571f0c82  pgSimload_static_non_stripped
ede2553587315d283081e5bc3b6ef5b8  pgSimload_win.exe

v.1.4.5

Version 1.4.5 (February, 13th 2025)

Major changes

• none this is mostly a monthly build, to refresh dependencies'versions

Minor changes

• corrected a bug where -loops <number> could be ignored when multiple clients were spawned with -clients <number>

• added a bit more info in the "SQL-Loop mode", showing number of scripts execution "per client" in parenthesis after the total number of "Script executions succeeded:"

• Thanks to Dimitri John Ledkov (@xnox) for his talk at FOSDEM 2025, build.sh creates better compilated binaries:

  • added GOAMD64=v2
  • added trimpath
  • added buildmode=pie
  • added -X 'main.Version=..'

• Added compilation for a non stripped version of the binary

• rebuild of binaries with dependencies updates:

  • upgraded golang.org/x/crypto to v0.33.0
  • upgraded golang.org/x/sys to v0.30.0
  • upgraded golang.org/x/text to v0.22.0

md5sum of binaries provided with the release

$ md5sum *
4ec13ff808b3122db555588731288c0e  pgSimload
f397addee8f53a9ebbe2b854db22b847  pgSimload_mac
246e9c98f71a68f2d4c7e0593833a6a4  pgSimload_static
7fbfd8e2025aa129f3dd15d25f979908  pgSimload_static_non_stripped
d456a99d6636710bd4fe8e4bba4fdb8c  pgSimload_win.exe

Version 1.4.4 (January 27th 2025)

Version 1.4.4 (January, 27th 2025)

Major changes

• none this is mostly a monthly build, to refresh dependencies' versions

Minor changes

• corrected a buggy output in Patroni Watched mode when it is monitoring a stand alone instance

• updated Crunchy copyright ranges to include 2025 (patch by @youattd)

• rebuild of binaries with dependencies updates:

  • upgraded github.com/jackc/pgx/v5 to v5.7.2
  • upgraded golang.org/x/crypto to v0.32.0
  • upgraded golang.org/x/sys to v0.29.0

md5sum of binaries provided with the release

$ md5sum *
30d9a4b774df8f40341bc5e62c27128d  pgSimload
b77f3f0437953ca3f93540676c8b61d6  pgSimload_mac
81731ea246920959bbe29ee3d1850cf3  pgSimload_static
79fc0c61fd73c115d6cf1a7e09988140  pgSimload_win.exe

v.1.4.3

Version 1.4.3 (December, 16th 2024)

Major changes

• none this is mostly a monthly build, to refresh dependencies'versions

Minor changes

• rebuild of binaries with dependencies updates:
  • upgraded golang.org/x/crypto v0.29.0 => v0.31.0
  • upgraded golang.org/x/sys v0.27.0 => v0.28.0
  • upgraded golang.org/x/text v0.20.0 => v0.21.0

md5sum of binaries provided with the release

$ md5sum *
1bbcc60a1b529bf21a5adf8e4cf0868d  pgSimload
d71689b955415ce40a6e2e59c8894c05  pgSimload_mac
4cd50316c58a9e1487b1a43b798ab298  pgSimload_static
14c69d9b64854e340a3b85d078431bdf  pgSimload_win.exe

v.1.4.2

Version 1.4.2 (November, 12th 2024)

Major changes

• none this is mostly a monthly build, to refresh dependencies'versions

Minor changes

• fixed a small typo in a sqlloop.go output

• removed bin/

  • to lighten sources!
  • binaries will be provided only within the releases starting from today
  • reviewed a bit documentation to act that change

• rebuild of binaries with dependencies updates:

  • upgraded golang.org/x/crypto v0.28.0 => v0.29.0
  • upgraded golang.org/x/sys v0.26.0 => v0.27.0
  • upgraded golang.org/x/text v0.19.0 => v0.20.0

md5sum of binaries provided with the release

$ md5sum *
cc363bb4e6baa3a5b367941912ef1e39  pgSimload
fc64f284eceff225c05a8d0d07b1ac0d  pgSimload_mac
fe7cead01b1d9295c16240595e069ff5  pgSimload_static
a9cbb049474b0eeab195e9f5771e2447  pgSimload_win.exe

v.1.4.1

Version 1.4.1 (October, 16th 2024)

Major changes

• Added a new parameter in command line: -rsleep time.Duration
  Like -sleep, this parameter will add a sleep time between 2 iterations (executions) of the -script script.sql (or whatever it's name).

  The difference is that the actual sleep time will be a random duration between 0 and that parameter. This is usefull when there are multiple -clients running, so they don't fire each at the same exact time... Or when one wants to execution to be just random.

  If used aside -sleep time.Duration, then the total sleep time between two iterations will be sum of both, one being a fixed duration and the other being a random one.

Minor changes

• review of examples in the documentation

NEW in the github release process

Thanks to Étienne BERSAC ( @bersace ) remarks:

• Publishing binaries directly in the release

• Binaries directly in the repo itself will be removed it pollutes a lot, making the repo way bigger than what it should

$ md5sum pgSimload*
8e2fef8861c61d81dcfa08f18d5c5e4c  pgSimload
eed6894cb131464e1b14c209d0f6236f  pgSimload_mac
8c80e9f2da22ad9a426945f54ec9019b  pgSimload_static
2c3016e3f89314dd950dcb82a13a4f27  pgSimload_win.exe

v.1.4.0

Version 1.4.0 (October, 11th 2024)

Major changes

• Added a new parameter in command line: -clients <integer>
  This parameter is only effective in the "SQL-Loop". It will create as many connections to the database to execute a given script in parallel, creating as many PostgreSQL connections as necessary, i.e. the number of clients declared here. There's no verification whatsoever of max_connections or any computation of free connections. So if the user specifies too many connections, an error message will be shown accordingly. If you need many (many) hundreds of concurrent connections, please consider the usage of a PostgreSQL pooler, like PgBouncer

Minor changes

• Support for Patroni v4 added, it was as simple as add the colorized output in patronictl for "Quorum Standby"

• raised the reconnection timeout from 20s to 60s (pgReconnectTimeout constant declared in pgmanager.go), because in certain scenarios where there are a lot of -clients used, the server may be in heavy load enough so 20s isn't sufficient. I'm planning to make this usage parameter rather than a constant, to give control to users

• first usage of the "sync" library in sqlloop.go, to manage synchronicity among Go Routines used when the -clients <integer> new parameter is used

• rebuild of binaries with dependencies updates:

  • upgraded github.com/jackc/pgx/v5 v5.6.0 => v5.7.1
  • upgraded golang.org/x/crypto v0.26.0 => v0.28.0

v.1.3.3

Version 1.3.3 (August, 28th 2024)

Major changes

• Added a new flag in command line: -silent

  With that parameter added, pgSimload won't show anymore the welcome message (copyright, program name and version, execution mode, etc.). The user will have to remember that the ESC key will still have to be pressed to get out of the execution loop

Minor changes

• Adding doc/build_doc.sh, making it public

• Reviewed the way the documentation is produced with internal script (doc/build_doc.sh). Had to change main.go to have Version and Release_date on separated variables

• Removed $ in $ command <exemples> so the reader can copy/paste the code directly reading the documentation on github. So it is a better user experience

• rebuild of binaries with dependencies updates:

  • upgraded golang.org/x/crypto v0.25.0 => v0.26.0
  • upgraded golang.org/x/sys v0.22.0 => v0.24.0
  • upgraded golang.org/x/text v0.16.0 => v0.17.0

v.1.3.2

Version 1.3.2 (July 10th 2024)

Major changes

None, this is a maintenance release.

Minor changes

• Fixed a bug in coloring patronictl (list|topology) command between "Leader" and "Standby Leader", now both are in red

• Fixed useless waiting loops in Patroni Watcher command, in the Kubernetes flavor. It's now more robust to what could happen inside the Kubernetes cluster.

• Fixed caption in "Patronictl output from...", there was too many spaces in there

• re-Build of binaries to update underlying dependencies:

  • upgraded golang.org/x/crypto v0.24.0 => v0.25.0
  • upgraded golang.org/x/sys v0.21.0 => v0.22.0