Postgres Pro
Downloads
Home   >   mailing lists

Re: How to create directory format backup - Mailing list pgsql-general

From Erik Wienhold
Subject Re: How to create directory format backup
Date
Msg-id 531831758.189866.1675891078338@office.mailbox.org
Whole thread Raw
In response to Re: How to create directory format backup  (Andrus <kobruleht2@hot.ee>)
Responses Re: How to create directory format backup  (Andrus <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Siddharth Jain
Date:
Subject: Re: How to use the BRIN index properly?
Next
From: Christophe Pettus
Date:
Subject: Re: How to use the BRIN index properly?