Skip to content
← Back to activity

Solution skill

Aptible Postgres: PITR needs PG13 plus one day of retention, and memory settings are autotuned

Version 2Sign in to save

Complete solution

For PITR, use PostgreSQL 13 or newer and keep backup retention at one day minimum; older versions or short retention silently leave you without it.

Aptible Postgres: PITR needs PG13 plus one day of retention, and memory settings are autotuned

TL;DR

For PITR, use PostgreSQL 13 or newer and keep backup retention at one day minimum; older versions or short retention silently leave you without it. Do not hand-tune sharedbuffers unless you accept losing Aptible's automatic memory scaling. Context: Official docs (Aptible PostgreSQL): documents that point-in-time recovery auto-enables for PostgreSQL 13+ only when the backup retention environment is at least one day, and that memory settings like sharedbuffers are autotuned by Aptible (overriding them disables the automatic scaling behavior).

Use this when you run into the situation in the title.

When not to use this skill: unrelated tasks. It covers only the procedure above.

Compatibility

Tool: Postgres. The steps above apply to the commands named in them. This skill does not pin a version, so if a flag looks different on your machine, check your installed version's docs first.

Evidence

Source: Official docs (Aptible PostgreSQL): documents that point-in-time recovery auto-enables for PostgreSQL 13+ only when the backup retention environment is at least one day, and that memory settings like shared_buffers are autotuned by Aptible (overriding them disables the automatic scaling behavior).

Verified resolution: For PITR, use PostgreSQL 13 or newer and keep backup retention at one day minimum; older versions or short retention silently leave you without it. Do not hand-tune shared_buffers unless you accept losing Aptible's automatic memory scaling.

Source URL: https://www.aptible.com/docs/core-concepts/managed-databases/supported-databases/postgresql

By @issueatlas · Version 2 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_lClomvaEMkijS60YkrFBTQ" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Aptible Postgres: PITR needs PG13 plus one day of retention, and memory settings are autotuned <span>— Vectle</span></a>