Jul 132024

Logical replication is a powerful feature in PostgreSQL that allows for real-time data replication between databases. It can be used for performing major version upgrades using a blue/green setup where you have two databases, allowing you to test and switch over to a new version with minimal downtime. Logical replication can also be use to facilitate database migrations between different environments, using the same technique and tooling.
In this post, I will describe the process of setting up simple replication and switchover between two databases using pg_easy_replicate.

External feed Read More at the Source: https://postgr.es/p/6zV

 2024-07-13  No Responses »
Jul 082024

The US Postal Service has been retaining metadata on snail mail for years. Back before mass scanning of every piece of mail was a reality, law enforcement requests had to be a bit more targeted. Investigators had to put in requests that required the postal service to log information about any mail sent to/from certain addresses or between certain addresses.
These days it’s far less complicated. As millions of Americans know, you have the option to have photos of all your incoming mail sent to your email, giving you a glimpse into the very near future in terms of mail service.
More than a decade ago, the technology finally achieved what law enforcement entities have always wanted:…

External feed Read More at the Source: https://www.techdirt.com/2024/07/08/for-whatever-reason-the-us-post-office-is-still-running-its-mail-cover-surveillance-program/

 2024-07-08  No Responses »
Jul 082024

Automated Major Version Upgrades in Percona Operator for PostgreSQLPostgreSQL major versions are released every year, with each release delivering better performance and new features. With such rapid innovation, it is inevitable that there will be a need to upgrade from one version to another. Upgrade procedures are usually very complex and require thorough planning. With the 2.4.0 release of Percona Operator for PostgreSQL, […]

External feed Read More at the Source: https://postgr.es/p/6zI

 2024-07-08  No Responses »
Jun 282024

Retailers are actively exploring and deploying facial recognition and analysis as part of their security and loss-prevention strategies to safeguard their customers and employees, margins and profitability. Corsight AI provides both face biometrics and computer vision analytics, and has a major new client to showcase its capabilities. Mall of America (MOA) has integrated facial recognition into its security infrastructure, joining forces with Corsight AI to implement its facial recognition system, which MOA lauds for its high accuracy, reliability, and privacy protection. There have been several firearms incidents at MOA over the past several years. The biometric system identifies Persons of Interest (POIs), including banned individuals or those trespassing at the mall, people who may pose…

External feed Read More at the Source: https://www.biometricupdate.com/202406/mall-of-america-deploys-corsight-facial-recognition-after-gun-incidents

 2024-06-28  No Responses »
Jun 282024

Well, we’ll see how long ShotSpotter/SoundThinking will keep making that New York money. The outlook is not good. A lot of this will depend on how well the NYPD can defend the useless product it’s spending millions on, but at the end of the day, the city still holds the purse strings and it has the power to terminate contracts that simply aren’t worth paying for.
The NYC comptroller performed an audit of the NYPD and ShotSpotter not with the intent of burying them, but simply to determine whether or not the NYPD was paying its bills on time and whether or not ShotSpotter was fulfilling the obligations of its contract.
The answer to both questions…

External feed Read More at the Source: https://www.techdirt.com/2024/06/27/nyc-comptroller-report-says-shotspotter-is-just-wasted-money/

 2024-06-28  No Responses »
Jun 282024

Today, the Supreme Court declined to issue a ruling in Idaho and Moyle, et al. v. United States. Instead, it sent the case back down to the lower courts where anti-abortion extremists will continue to fight to strip pregnant people of the basic right to emergency care, including when their life is at risk.
While the court’s decision temporarily restores the ability of doctors in Idaho to provide emergency abortions required under the federal Emergency Medical Treatment and Labor Act —EMTALA— by dismissing the case without affirming once and for all that pregnant people have a right to the emergency abortion care they need to protect their health and lives, the court continues to put pregnant patients…

External feed Read More at the Source: https://www.aclu.org/news/reproductive-freedom/the-supreme-court-just-declined-to-protect-emergency-abortion-care-for-pregnant-patients-heres-what-to-know

 2024-06-28  No Responses »
Jun 252024

The United States has now, for the first time in the more than 100-year history of the Espionage Act, obtained an Espionage Act conviction for basic journalistic acts. Here, Assange’s Criminal Information is for obtaining newsworthy information from a source, communicating it to the public, and expressing an openness to receiving more highly newsworthy information. This sets a dangerous practical precedent, and all those who value a free press should work to make sure that it never happens again. While we are pleased that Assange can now be freed for time served and return to Australia, these charges should never have been brought.
Additional information about this charge: 

EFF Statement on Assange Indictment and Arrest (April 11,…

External feed Read More at the Source: https://www.eff.org/deeplinks/2024/06/eff-statement-assange-plea-deal

 2024-06-25  No Responses »
Jun 172024

Surgeon General Vivek Murthy’s extraordinarily misguided and speech-chilling call this week to label social media platforms as harmful to adolescents is shameful fear-mongering that lacks scientific evidence and turns the nation’s top physician into a censor. This claim is particularly alarming given the far more complex and nuanced picture that studies have drawn about how social media and young people’s mental health interact.
The Surgeon General’s suggestion that speech be labeled as dangerous is extraordinary. Communications platforms are not comparable to unsafe food, unsafe cars, or cigarettes, all of which are physical products—rather than communications platforms—that can cause physical injury. Government warnings on speech implicate our fundamental rights to speak, to receive information, and to think. Murthy’s…

External feed Read More at the Source: https://www.eff.org/deeplinks/2024/06/no-online-speech-should-not-have-warning-labels

 2024-06-17  No Responses »
Jun 112024

Iranian authorities have shared more details on the country’s upcoming law introducing facial recognition surveillance against women who fail to wear hijabs. According to the proposed Hijab and Chastity Bill, the police must create “intelligent systems for identifying perpetrators of illegal behavior using tools such as fixed and mobile cameras,” Iran International reports. Another article of the law requires the private sector including banks, transport companies, stores and businesses to upload CCTV footage to the police command of the Islamic Republic of Iran (FARAJA)” to identify violators. “We mandate that all entities, including the private sector to provide their cameras to FARAJA. All cameras must be connected to FARAJA,” says Amir Hossein Bankipour, a member…

External feed Read More at the Source: https://www.biometricupdate.com/202406/iran-shares-more-on-using-facial-recognition-to-police-hijabs

 2024-06-11  No Responses »
Jun 112024

What’s German for ‘thank goodness for actually useful privacy regulations’?

Meta will start training its AI models using everyone’s social media posts though European Union users can opt out, a luxury the rest of the world won’t enjoy.…

External feed Read More at the Source: https://go.theregister.com/feed/www.theregister.com/2024/06/10/meta_ai_training/

 2024-06-11  No Responses »
Jun 072024

Learn how the combination of ORDER BY and LIMIT clauses in PostgreSQL affects query performance, and discover optimization techniques to maintain efficient database performance and fast query responses.

The post Performance impact of using ORDER BY with LIMIT in PostgreSQL appeared first on Stormatics.

External feed Read More at the Source: https://postgr.es/p/6wL

 2024-06-07  No Responses »
Jun 052024

Enlarge / Hubble Space Telescope above Earth, photographed during STS-125, Servicing Mission 4, May 2009. (credit: NASA)
The venerable Hubble Space Telescope is running out of gyroscopes, and when none are left, the instrument will cease to conduct meaningful science.
To preserve the telescope, which has been operating in space for nearly three and a half decades, NASA announced Tuesday that it will reduce the Hubble’s operations such that it will function on just a single gyroscope. This will limit some scientific operations, and it will take longer to point the telescope to new objects and lock onto them.
But in a conference call with space reporters, Hubble officials stressed that the beloved scientific instrument…

External feed Read More at the Source: https://arstechnica.com/?p=2029000

 2024-06-05  No Responses »
Jun 052024

It appears that North Carolina will have seven parties on the ballot this year, the most ever.  The previous record was in 1980, when there were six parties on the ballot in North Carolina.  See this story.
The seven are:  Republican, Democratic, Libertarian, Green, Constitution, We the People, and Justice for All.  The latter two were formed by independent presidential candidates.  We the People will nominate Robert F. Kennedy, Jr.; Justice for All will nominate Cornel West.
No Labels is also a qualified party in North Carolina, but it won’t appear on the ballot because it isn’t running anyone.  In North Carolina, new parties nominate by convention, and state officials of No Labels will obey the No Labels’…

External feed Read More at the Source: https://ballot-access.org/2024/06/04/north-carolina-likely-to-have-seven-parties-on-the-ballot-the-most-ever/

 2024-06-05  No Responses »
Jun 052024

You accelerated multiple times on your way to Yosemite for the weekend. You braked when driving to a doctor appointment. If your car has internet capabilities, GPS tracking or OnStar, your car knows your driving history.
And now we know: your car insurance carrier might know it, too.
In a recent New York Times article, Kashmir Hill reported how everyday moments in your car like these create a data footprint of your driving habits and routine that is, in some cases, being sold to insurance companies. Collection often happens through so-called “safe driving” programs pre-installed in your vehicle through an internet-connected service on your car or a connected car app. Real-time location tracking often starts when you download…

External feed Read More at the Source: https://www.eff.org/deeplinks/2024/06/car-makers-shouldnt-be-selling-our-driving-history-data-brokers-and-insurance

 2024-06-05  No Responses »
Jun 042024

Kind of an odd bit of Fourth Amendment jurisprudence here, given all the factors. (h/t FourthAmendment.com)
Obviously, some conversations have an expectation of privacy, even when they’re held in police interrogation rooms. Those would be ones between the suspect and their legal representation. But that’s not really a Fourth Amendment issue as it is about privileged communications. The government isn’t allowed to eavesdrop on suspects as they work on a legal defense and/or make statements to their lawyer.
Then there’s the assumption that pretty much everything a cop would like to listen to is recorded, starting with anything said in interrogation rooms (minus attorney-client communications) and ending with phone calls placed from jail phones. (On the other hand,…

External feed Read More at the Source: https://www.techdirt.com/2024/06/03/state-court-says-theres-a-reasonable-expectation-of-privacy-in-conversations-with-non-cops-in-interrogation-rooms/

 2024-06-04  Comments Off on Techdirt. – State Court Says There’s A Reasonable Expectation Of Privacy In Conversations With Non-Cops In Interrogation Rooms
Jun 042024

Version 2.4.0 of the LyX
document processor has been released. LyX is a “What You See Is What You
” (WYSIWYM) application that offers GUI editing of LaTeX
documents with import and export to PDF, HTML, OpenDocument, Word, and
other formats. LyX 2.4.0 is the first major release in six years, and
brings support for EPUB, DocBook 5, improved
table styles, and now uses Unicode (utf8) as its default encoding. See
the full list of new
features on the LyX wiki, and release
for information on known issues and caveats for those
upgrading from earlier versions of LyX.

External feed Read More at the Source: https://lwn.net/Articles/976826/

 2024-06-04  Comments Off on LWN.net – LyX 2.4.0 Released
Jun 012024

In this month’s “Notes from the Editors,” the editors confront the myth of Marx’s purported early Prometheanism and later rejection of the growth of productive forces altogether, favoring a “no-growth path to communism.” This ahistorical interpretation has engendered further critique of ecosocialism and degrowth on the part of self-identified productivist writers, who attempt incorrectly to paint degrowth as a Malthusian project, rather than a realistic effort to live within Earth’s planetary capacities. | more…


External feed Read More at the Source: https://monthlyreview.org/2024/06/01/mr-076-02-2024-06_0/?utm_source=rss&utm_medium=rss&utm_campaign=mr-076-02-2024-06_0

 2024-06-01  Comments Off on Monthly Review – June 2024 (Volume 76, Number 2)
May 312024

The American and European imperialist powers are recklessly escalating the war with nuclear-armed Russia towards a global conflagration, which can be halted only through the political mobilisation of the international working class in opposition to imperialist war.

External feed Read More at the Source: https://www.wsws.org/en/articles/2024/05/31/hfed-m31.html

 2024-05-31  Comments Off on World Socialist Web Site (en) – Biden gives go-ahead for NATO attacks on Russia: A new stage in the escalating imperialist world war
May 302024

404 Media has a good article explaining the new DOJ suit: The Justice Department’s antitrust lawsuit against Live Nation/Ticketmaster isn’t really about high ticket prices, or ticket scalpers, or any individual offense. It is about a systematic vertical integration of the entire live music business, which has led to the company’s dominance over tickets, yes, but also over live music venues, artists’ tour booking, and concert promotion. […] In simple terms, Live Nation, which owns Ticketmaster, is not just selling fans tickets on Ticketmaster.com. It owns, operates, or has exclusive contracts with the vast majority of midsized and large concert venues, and a supermajority of all outdoor pavilions and amphitheaters. And it has a…

External feed Read More at the Source: https://www.dnalounge.com/backstage/log/2024/05/30.html

 2024-05-30  Comments Off on jwz – DNA Lounge: Wherein DOJ finally has the knives out for multinational superpredator Live Nation / Ticketmaster.