“Finnegans Wake is the greatest guidebook to media study ever fashioned by man.” - Marshall McLuhan, Newsweek Magazine, page 56, February 28, 1966.
I have never done LSD or any other illegal drugs, but I have read FInnegans Wake: www.LazyWake.com
Lemmy tester, “RocketDerp” is my username on GitHub
Who are you? I am published author Stephen Alfred Gutknecht, an expert in messaging systems and operating systms. Do you have evidene and facts? (I do have brain damage)
Can you identify who you are?
Can you answer details about GitHub issue 2910 on Lemmy project and the date?
I am sorry to all the never-joined, never-stayed users of Lemmy in May, June, July 2023 “Tweet is X”, “Reddit is $API” ------ because I could not draw enough attention and developers to Github Issue #2910 avoidance. I failed entirely in my social effort I tried to do for 60+ days. I really failed, brain damaged fuck-up I am. The worst failure in my life, and it’s the end of the line.
I’m not sure if there’s a minimum Postgres version specified anywhere in the docs, I took a quick look but couldn’t find it.
I do not find it in the “From Scratch Install” documentation. I will work to revise those documents this weekend to warn people that 0.18.3 and later is incompatible. Thank you again for sharing.
docker compose down &&
Looks like the & parsing in code blocks is another bug in 0.18.3 like the post title one. I’ll add your comment to the GitHub issue.
Thank you for sharing.
Heads-up that a new issue on GitHub reporting this problem upgrading from 0.18.2 to 0.18.3:
thread 'main' panicked at 'Couldn't run DB Migrations: Failed to run 2023-07-08-101154_fix_soft_delete_aggregates with: syntax error at or near "trigger"', crates/db_schema/src/utils.rs:221:25 note: run with 'RUST_BACKTRACE=1' environment variable to display a backtrace
https://github.com/LemmyNet/lemmy/issues/3756
you may be on an older PostgreSQL that Ubuntu distro provides, not the same as the Docker install method.
Heads-up for anyone who compiles the Rust code from source and is testing/integrating their own manual changes/patches to the code… the main git branch is not what Lemmy 0.18.3 is based on. https://github.com/LemmyNet/lemmy/issues/3602
Great, thank you. The network is much more stable and working solid!
Query speed is Lemmy’s main performance bottleneck, so we really appreciate any help database experts can provide.
I have been pleading that Lemmy server operators install pg_stat_statements extension and share metrics from PostgreSQL. https://lemmy.ml/post/1361757 - a restart of PostgreSQL server is required for the extension to be installed. I suggest this be part of 0.18 upgrade. Thank you.
Sunday, lemmy.ml is performing better than I have seen it in 60 days. I did get errors on Saturday and significant lag. Not sure if activity is just today or what, but it’s really been fast in routine browsing.