Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1vWdvi-006Sz4-35
	for pgsql-general@arkaria.postgresql.org;
	Fri, 19 Dec 2025 17:06:15 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1vWdvQ-008XV9-2X
	for pgsql-general@arkaria.postgresql.org;
	Fri, 19 Dec 2025 17:05:57 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <cmt@burggraben.net>)
	id 1vWdvQ-008XV0-1U
	for pgsql-general@lists.postgresql.org;
	Fri, 19 Dec 2025 17:05:57 +0000
Received: from smtp.burggraben.net ([2a01:4f8:140:510a::3])
	by makus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <cmt@burggraben.net>)
	id 1vWdvL-001XTR-2N
	for pgsql-general@postgresql.org;
	Fri, 19 Dec 2025 17:05:56 +0000
Received: from elch.exwg.net (elch.exwg.net [IPv6:2001:470:7120:1:21b:21ff:fef0:248b])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(Client CN "elch.exwg.net", Issuer "R13" (not verified))
	by smtp.burggraben.net (Postfix) with ESMTPS id 89EA6C00311;
	Fri, 19 Dec 2025 18:05:44 +0100 (CET)
Received: by elch.exwg.net (Postfix, from userid 1000)
	id 45010FE59C; Fri, 19 Dec 2025 18:05:44 +0100 (CET)
Date: Fri, 19 Dec 2025 18:05:44 +0100
From: Christoph Moench-Tegeder <cmt@burggraben.net>
To: Andrus <kobruleht2@hot.ee>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: How to get single table data from backup
Message-ID: <aUWF6BGWp4E27IRO@elch.exwg.net>
References: <ff66d3ac-2e78-41ee-a511-7f934cb388ac@hot.ee>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <ff66d3ac-2e78-41ee-a511-7f934cb388ac@hot.ee>
User-Agent: Mutt/2.2.16 (2025-11-22)
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/aUWF6BGWp4E27IRO%40elch.exwg.net>
Precedence: bulk

## 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