Additive backup and restore?

From: Age Apache <age(dot)apache(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Additive backup and restore?
Date: 2023-05-08 10:24:06
Message-ID: CAD80oWbOgVG=EVYukKifnBbhuE8oZ6tL3iAiHUynzJ18n_+f2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am designing a database for a web application. In the near future I will
require past data for Audit, Security and Analysis purpose. But storing all
that data will increase the database size. What are some well known
approaches to archiving data for later use without increasing the database
size?

One approach I am thinking of is compressed additive backup and restore
i.e. copy the rows of the tables that will be required later and store them
in a compressed form, and then delete those rows from the table. And when
the data is required then restore them from the backup files in an additive
way.

Is there an easy way to achieve this, say via pg_dump?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message shveta malik 2023-05-08 10:28:54 Re: Support logical replication of DDLs
Previous Message Alvaro Herrera 2023-05-08 09:53:49 Re: "PANIC: could not open critical system index 2662" - twice