Request a Demo
Home   >   mailing lists

Re: How to get single table data from backup - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: How to get single table data from backup
Date
Msg-id aUWF6BGWp4E27IRO@elch.exwg.net
Whole thread Raw
In response to How to get single table data from backup  (Andrus <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
## Andrus (kobruleht2@hot.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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to get single table data from backup
Next
From: Laurenz Albe
Date:
Subject: Re: Dealing with SeqScans when Time-based Partitions Cut Over