Horton
Menu

Re: How to create directory format backup

Erik Wienhold <ewie@ewie.name>

View thread
From: Erik Wienhold <ewie@ewie.name>
To: Andrus <kobruleht2@hot.ee>, depesz@depesz.com
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2023-02-08T21:17:58Z
Lists: pgsql-general 
> On 08/02/2023 21:59 CET Andrus <kobruleht2@hot.ee> wrote:
>
> How to create backup in format from which tables can selectively restored?

Dump as custom-format archive (-F custom) and use that with pg_restore and
options --table or --list/--use-list to select what should be restored.

--
Erik