Re: How to get single table data from backup

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get single table data from backup
Date: 2025-12-19 17:05:44
Message-ID: aUWF6BGWp4E27IRO@elch.exwg.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Andrus (kobruleht2(at)hot(dot)ee):

> This fails since tabletorecover contains lot foreign key references.

Check pg_restore options "--section=pre-data" and "--section=data" -
pre-data is the schema without indexes, contraints, etc. (those
would be in section post-data).

Regards,
Christoph

--
Spare Space

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2025-12-19 17:42:34 Re: Dealing with SeqScans when Time-based Partitions Cut Over
Previous Message Adrian Klaver 2025-12-19 16:23:42 Re: How to get single table data from backup