…) (#19765)This is required by#19756 The latest release of all `pg_dump` major versions, going back to 13,started inserting `\restrict` `\unrestrict` keywords into dumps. Thiscurrently breaks sqlc in `gen/dump` and our check migration script. Fulldetails of the postgres change are available here:https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=575f54d4cTo fix, we'll always use the `pg_dump` in our postgres 13.21 dockerimage for schema dumps, instead of what's on the runner/local machine.Coder doesn't restore from postgres dumps, so we're not vulnerable toattacks that would be patched by the latest postgres version.Regardless, we'll unpin ASAP.Once sqlc is updated to handle these keywords, we need to startstripping them when comparing the schema in the migration check script,and then we can unpin the pg_dump version. This is being tracked atcoder/internal#965Co-authored-by: Ethan <39577870+ethanndickson@users.noreply.github.com>

…y from entitlements (#19747) (#19756)This PR addresses the significant database load issue where theGetWorkspaces query was causing performance problems in the licenseentitlements code.cherry picked from commit3074547

Co-authored-by: Danielle Maywood <danielle@themaywoods.com>

# For release 2.26- Ignore errors when reporting a connection from the server, just logthem instead- Translate connection log IP `localhost` to `127.0.0.1` on both theserver and the agent- Temporary fix: convert invalid IPs to `127.0.0.1` since the databaseforbids NULLRelates to#20194

coder/clistat has received a handful of bug fixes so we're back-portingthese bug fixes to 2.26---Cherry-picked from9bef5de

…26] (#20491)> Resolved an invalid parameter error (-2147024809) during PTY creationon Windows 11 22H2 (but not only) when connecting via JetBrains Toolboxwhich spawns the native SSH client with `-tt` forcing PTY allocationeven though there is no "terminal" on the client side to query its size.>> CreatePseudoConsole doesn't accept a 0x0 (zero width and zero height)console size and unfortunately, there is NO explicit documentation inthe official Microsoft documentation that states the minimum validvalues or explicitly prohibits 0x0.>> Looking at real-world implementations in the search results, allexamples use reasonable non-zero values.>> I tested this with a local Windows VM registered to dev.coder.com i.e.externally managed workspace.Relates to#20468Co-authored-by: Faur Ioan-Aurel <fioan89@gmail.com>

(cherry picked from commit81c3375)Signed-off-by: Danny Kopping <danny@coder.com>Co-authored-by: Danny Kopping <danny@coder.com>

Backport of#20968Co-authored-by: Sas Swart <sas.swart.cdk@gmail.com>

Backport of#20863