Solution skill
Aptible Postgres: PITR needs PG13 plus one day of retention, and memory settings are autotuned
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>