Paused CDC Connector Left Replication Slot Holding WAL, Filling Postgres Disk

·1 views

A Postgres primary database shut down after its disk filled, because a paused CDC connector's replication slot had kept all write-ahead log since it was stopped nine days earlier. Replication slots record the oldest WAL position a consumer needs, and by default Postgres retains that WAL without limit, so it keeps growing while the connector is idle. A quieter variant can occur even when the connector runs, if captured tables rarely change and the confirmed position lags behind. The article recommends heartbeat settings, including a dedicated heartbeat table in the captured database, plus Postgres safeguards such as max_slot_wal_keep_size and idle slot timeouts.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Tracking Google Flights prices with Python via a scraper, no API key needed

Google Flights offers no public API, so the article proposes a scraper-based approach to monitor fares across many routes and dates. The author's Apify Actor, Google Flights Scraper, collects total price, airlines, times, duration, stops, layovers, leg details, CO2 emissions, and a direct booking link for each flight. Users specify origin and destination airports and date ranges, and can filter by cabin class, stops, currency, and round-trip length. A short Python script using the Apify client exports the cheapest fare per departure date to CSV. The article also explains how to schedule daily runs to track price changes, noting the disclosed cost of roughly $0.20 per 1,000 flights.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

CrewAI and AutoGen Compared on Coordination, Token Use, and Stability for Multi-Agent Systems

A DEV Community analysis compares CrewAI and AutoGen, the two leading multi-agent orchestration frameworks used in production AI engineering. CrewAI uses role-based hierarchies and deterministic Flows, while AutoGen relies on conversational, message-passing agent groups. In benchmarks of 5,000 multi-step research and code triage tasks on Python 3.12 with GPT-4o and Claude 3.5 Sonnet, CrewAI's structured Flows reportedly cut token waste by 46%. The article says CrewAI also reduced runaway chat loops by 91.4% in business pipelines, whereas AutoGen offers greater flexibility for open-ended, exploratory debugging.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Freelance web designers can protect profits by setting clear client revision limits

A DEV Community guide explains how freelance web designers can manage client revisions without losing money. It recommends stating a fixed number of included revision rounds in the contract instead of offering unlimited changes. The guide advises separating routine revisions from scope changes, such as adding new pages or features, which should be quoted separately. It also suggests tracking feedback, reminding clients of remaining rounds, and securing approvals at staged milestones before development begins.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

DOM: How JavaScript Reads and Changes Web Page Elements

The Document Object Model (DOM) is a programming interface that lets JavaScript access and modify HTML elements, their content, styles, and attributes. A simple example shows JavaScript selecting a heading by its ID and replacing its text from "Hello World" to "welcome". The article outlines core selection methods, including getElementById, getElementsByClassName, getElementsByTagName, querySelector, and querySelectorAll. It also covers changing HTML content and CSS styles through the DOM, along with handling user events such as button clicks.

0 comments Read more at DEV Community