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 ) id 1vZFoa-006khu-0v for pgsql-general@arkaria.postgresql.org; Fri, 26 Dec 2025 21:57:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vZFoY-00ACvR-2z for pgsql-general@arkaria.postgresql.org; Fri, 26 Dec 2025 21:57:39 +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 ) id 1vWhhn-0091Zd-23 for pgsql-general@lists.postgresql.org; Fri, 19 Dec 2025 21:08:08 +0000 Received: from smtpout05.dka.mailcore.net ([185.138.56.205]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vWhhm-001ZBi-19 for pgsql-general@postgresql.org; Fri, 19 Dec 2025 21:08:07 +0000 Received: from SMTP.DKA.mailcore.net (unknown [10.1.0.52]) by SMTPOUT01.DKA.mailcore.net (Postfix) with ESMTP id CA7F9E0099; Fri, 19 Dec 2025 22:08:03 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=online.ee; s=mailcore; t=1766178483; bh=3HSi/sm76Qy0aiE3YTDFYdFspkYcruhzUUKT0NLU/r0=; h=Date:Subject:To:Cc:References:From:In-Reply-To:From; b=eHSbGsYMAd9e3LDFANzyxxQ9p/ryOIcnsj/upBBaq8fQn5kcrfk5YYe7BG3zgolLF /0TzTo7X0QnNWAOwEEbnkv6C5eyUl2oVGu+BolPPeyfJohjLHAMQhxfdS9MOf3Zkyq c3wPD5LPT0cq2lVZ9pRK998L7ANoUx3qlfSwTbrE2LDNZat6vj8v15YpmAXbX6aYIk Bqnh4APYtfeoIxiT5oPbEsTUgYu2cTkHSTy9aMmtyOW3dyOV4VSFUyqFmzLbvaqsSn tgy4whg2fu7nXxIIOBjxswbBsePGu8vdmhUmqVySX3mF1oX8qYq3s7SsqTxHRXLYCM HicEhjZbsCFeQ== Received: from [192.168.1.38] (73-142-35-213.sta.estpak.ee [213.35.142.73]) by SMTP.DKA.mailcore.net (Postfix) with ESMTPSA id A4F4740190; Fri, 19 Dec 2025 22:08:03 +0100 (CET) Content-Type: multipart/alternative; boundary="------------lVWhqXWgwpoLKu5SK0DmX0dL" Message-ID: <5b7b0914-ae51-48cb-a6a8-db678f42ebd5@hot.ee> Date: Fri, 19 Dec 2025 23:08:11 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: How to get single table data from backup To: Christoph Moench-Tegeder Cc: pgsql-general References: Content-Language: et From: Andrus In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------lVWhqXWgwpoLKu5SK0DmX0dL Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi! Geat answer since doesnt require manual sql editing. It worked. Thank you. Andrus. 19.12.2025 19:05 Christoph Moench-Tegeder kirjutas: > ## 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 > --------------lVWhqXWgwpoLKu5SK0DmX0dL Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Hi!

Geat answer since doesnt require manual sql editing. It worked.

Thank you.

Andrus.

19.12.2025 19:05 Christoph Moench-Tegeder kirjutas:
## 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
--------------lVWhqXWgwpoLKu5SK0DmX0dL--